rdo bug when SQL contains aliases

Bruce -- bmiller@geographix.com
Thursday, January 30, 1997


Environment: VC++ 4.2b, NT 4.0

I am using the Sheridan DataWidgets grid OCX (although this problem
appears with other grids) in conjunction with the RemoteData control to
display data from a Sybase SQLAnywhere database.  If the SQL property of
the RemoteData control contains an alias (e.g., 'Select field as "My
field" from table') I get a SQL error in MSRDC32 when modifying data: 
MSRDC32, 37000:[Sybase][ODBC Driver]Syntax eror: near 'Field' in
...table set My [Field]= ? where current...

Apparently the space in the alias is the culprit.  Has anyone solved
this problem?

Bruce
Bruce Miller
Software Engineer
Geographix, Inc.

bmiller@geographix.com
303-675-2457

---

Doug Brubacher -- Doug_Brubacher@compuware.com
Tuesday, February 04, 1997

     I have not tried this but I know with ODBC it was a good practice to 
     place square brackets [] around tables and field names that contained 
     spaces.
     
     Hope this helps,
     
     Regards
     
     Doug Brubacher
     Doug_Brubacher@compuware.com

---

| Вернуться в корень Архива |