Mensaje
De
29/06/2001 09:00:18
 
 
a
28/06/2001 16:30:11
General information
Foro:
Visual FoxPro
Category:
Bases de datos, tablas, vistas, índices y SQL
Miscellaneous
ID de la conversación:
00524748
ID del mensaje:
00525127
Views:
18
>Yes, surround the entire source field name in quotes. In the remote view, though, make sure it maps out to a field name without quotes. After you have created the view, run GENDBC and make any changes as required to the output code and re-run if you have to.
>
>>I am doing some work with an ODBC data source "LinkBook" (using a 3rd party ODBC driver). This driver allows you to access QuickBooks files. When it generated the code for the remote view, I noticed that the field names for the QuickBooks file were coded ' filename."Field Name" ' (no outer quotes) for the fields with spaces in their names (Address 1, etc.).
>>
>>When VFP tried to execute the SQL statement it abended on an illegal name error (or something similar).
>>
>>I was just wondering if the entire ' filename."Field Name" ' should be surrounded by quotes as in "filename.Field Name" ?
>>
>>Thanks in advance.

I got some feedback from the ODBC author. He gave me some debugging tips which I'll work with over the weekend. I just wish the feedback from VFP were a bit more meaningful.

Thanks for your help.
Steven Herbin
SNH Computing Corporation
Swan Lake, NY
Previous
Responder
Mapa
Ver