Question about Databases

[JonnyBRadio]

I have an application that generates a DBF file at runtime, with a filename as specified by the user. It then saves that DBF file.

I have another application that needs to read that file. But everytime I try to open the table, I get

"PlaylistTable: Type mismatch for field 'SONGYEAR', expecting: Smallint actual: Float."

I dont understand, because the field SONGYEAR is a smallint field in both programs. I never designated it as a float anywhere.

If anyone has any ideas, I would REALLY appreciate them. I'm about to pull out my hair. Thanks!

 

[lespaul]

have you looked at the data in the table to make sure that there isn't anything funky in the data?

Leslie

Have you met Hardy Heron?

 

[roo0047]

Try this:
Open the form where your table is defined and double-click the TTable icon to bring up the fields editor.
Right-click inside the fields editor window and select "Select All".
Right-click inside the fields editor window again and select "Delete" (all).
Right-click inside the fields editor window one more time and select "Add all fields".
Compile and run.
Your problem should be resolved.

HTH

Roo
Delphi Rules!

 

[gcaramia]

I think that in dbf structure there is not field type 'smallint' but only 'Number' that is = float
Gianni