[RBASE-L] - RE: Sql Server table

[Troy Sosamon]

This is from the on-line R:base help. SSQL is used to send an sql statement to another database and it passes it through unaltered.   Troy     Name: SSQL Shortest: SSQL Family: Command Category: Server Access Description: Use SSQL to pass SQL commands through R:BASE to the foreign data source, where they will be interpreted and executed. Syntax Options SQLcommand Specifies the SQL command to send. About the SSQL Command SSQL requires R:BASE to already be connected to the data source. With a few exceptions, you can use every SQL command supported by the connected data source. You cannot use commands that usually return data, such as SELECT commands. To retrieve data from a foreign table, attach the table and use standard R:BASE commands. SSQL can be used to send structure modification commands that alter the foreign database subject to the access rights and restrictions placed on the user by the foreign database. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Roberto Zanotti Sent: Monday, June 30, 2003 1:05 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Sql Server table Dear Dan   Whath do you mean with ssql statement ?   Where can I find some examples ?   Roberto Zanotti BMB Informatica Italy   ----- Original Message ----- From: Dan Goldberg To: RBASE-L Mailing List Sent: Friday, June 27, 2003 3:28 PM Subject: [RBASE-L] - RE: Sql Server table You might try using the ssql statement.   Dan     -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Roberto Zanotti Sent: Friday, June 27, 2003 1:32 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Sql Server table Yes, I've tried with different tables and with different clients (ME,2000,XP) but i get always the same error.     Roberto Zanotti BMB Informatica Italy ----- Original Message ----- From: Walker, Buddy To: RBASE-L Mailing List Sent: Thursday, June 26, 2003 5:20 PM Subject: [RBASE-L] - RE: Sql Server table Have you tried a different table?   Buddy