General information
Category:
Database DAO/RDO/ODBC/ADO
>It is a Paradox 4.5 data base. My "feel" is that it has do with the # character, because if I use any of the other two key fields that do not have the # character, it works just fine. The only trouble is when I use the particular field name [Contract #], even if I add it to the query that is working with the other 2 key fields.
>
>Seems like I remember that if I import this table in to Access, it converts the # in the field name to a period. Does this have implications on my query?
>
I suppose it will no longer work if you use [Contract .] as opposed to [Contract #]. You would have to adjust for that in the query. Is this a valid character for a paradox field name?
>Also, if I want to SELECT all records that have no value for [Contract #] do I query for [Contract #] = NULL?
>
It depends on what is the syntax for the paradox SQL. ANSI SQL standard checks for nulls like so: WHERE [Contract #] IS NULL. If this is not supported then the paradox SQL reference should give you an answer, as I am not familiar with it.
>Thank you,
>John
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only