Data type mismatch!!!???

[jrajesh]

Hello all,
I am unable to find why I'm getting this error :-(
"Data Type Mismatch"

All my tables and views are in the DE.
I'm using the navigation bar (with Save/revert buttons) in the form.
When I click on save, I get this error, but the data gets saved properly.
When I go to the debugger, this is the line with error:

Select QuotMast

Please help.. Really desperate..
Thanks all,
Regards,
Rajesh

P.S.: I have 3 combo boxes and all of them are populated from tables. The rest of the fields are all textboxes.

 

[DEDMOD]

We really need to know what type the fields you're using are and what code you're using. A lot of times dates are the problem, but sometimes something needs to be quoted or not quoted or any of a number of other things.

However, if the error is indeed where you indicate, it's likely that there is no workspace with a tablealias of 'quotmast'.

Dave Dardinger

 

[ramani]

HI
The problem in all probability comes from one of your combo boxes for which the table field is a date field. The combo boxes when get populated, they read the table field of Date type correctly and populate the combo as character type. When you save the record, you may be simply storing the combo value which is character type to the date field type. So at the save place, if you convert the character type to date type with CTOD(), the error will disappear.

Hope this helps
ramani :-9
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[jrajesh]

Ramani and DEDMOD,
Sorry. I didn't check your reply earlier and had assumed that there was no reply.

The structure of QuotMast:
1     QUOTENO    Character    20    
2     AGMTCODE   Character    25    
3     REQUESTBY  Character    40    
4     REQSTDATE  Date         8     
5     PREPAREDBY Character    20    
6     QUOTEDATE  Date         8     
7     SENTMETHOD Character    30    
8     VESSELNAME Character    30    
9     VESSELTYPE Character    10    
10    OWNR_MGR   Character    30    
11    YEARBUILT  Character    15    
12    FLAG       Character    10    
13    BUDGETPRD  Numeric      5     2
14    STARTMTH   Date         8     
15    ENDMTH     Date         8     
16    TECHORCREW Logical      1     
17    QUOT_BDGT  Character    10    
18    TAKEOVRVSL Logical      1     
19    RVSNNUMBER Numeric      6     2
20    COMMENTS   Memo         4

and the combo boxes do not have a date field as source.
Is there some way to upload my form to this site?
If so, maybe someone can take a look at the form and help me.
Regards,
Rajesh

 

[jrajesh]

Ramani and DEDMOD,
Sorry. I didn't check your reply earlier and had assumed that there was no reply.

The structure of QuotMast:
1     QUOTENO    Character    20    
2     AGMTCODE   Character    25    
3     REQUESTBY  Character    40    
4     REQSTDATE  Date         8     
5     PREPAREDBY Character    20    
6     QUOTEDATE  Date         8     
7     SENTMETHOD Character    30    
8     VESSELNAME Character    30    
9     VESSELTYPE Character    10    
10    OWNR_MGR   Character    30    
11    YEARBUILT  Character    15    
12    FLAG       Character    10    
13    BUDGETPRD  Numeric      5     2
14    STARTMTH   Date         8     
15    ENDMTH     Date         8     
16    TECHORCREW Logical      1     
17    QUOT_BDGT  Character    10    
18    TAKEOVRVSL Logical      1     
19    RVSNNUMBER Numeric      6     2
20    COMMENTS   Memo         4

and the combo boxes do not have a date field as source.
Is there some way to upload my form to this site?
If so, maybe someone can take a look at the form and help me.
Regards,
Rajesh

 

[DEDMOD]

I'd be happy to look at your form if you want to try to send to me at dedmod@msn.com, but it'd be helpful the have copies of the tables with sample data too, since otherwise it'd take a lot of effort to get it to the testing stage.
Dave Dardinger

 

[ramani]

HI
CHeck your index for the table. If you have used a compound index with multiple fields and the + sign used between two different types of fileds, the error can come.

Hope this helps you or you can email me the form.
ramani :-9
(Subramanian.G),FoxAcc, ramani_g@yahoo.com