Re: Oracle/Sybase server recommendations?

In article <D39JAG.CGE_at_mercury.co.il>, wygodny_at_metal.mercury.co.il (Shlomo Wygodny) writes:
|> Just a short observation from someone who is NOT an expert in SQL link-
|> I found the following problem when trying to migrate a Paradox application to
|> Sybase server: In sybase, all tables have a name which looks like:
|> <owner>.<table name>. This means that all the ObjectPAL code you written which
|> accesses tables will have to be changed.

If the tables are owned by the database owner (dbo), then you don't have to qualify the table name with the owner's name. So make sure you are logged in as dbo when you create your tables.

                                Teresa Larson

+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+
| Teresa A. Larson - Hughes STX Corporation                            |
| NASA/GSFC Code 933.0                        voice:  (301) 286-7867   |
| Greenbelt, Maryland  20771                  fax:    (301) 286-1777   |
| Teresa.Larson_at_gsfc.nasa.gov                                          |
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+
			Standard disclaimer ...