General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>need code to create remote views from local views like upsize wizard.
>i don't want to use upsize wizard because sending datas from larges tables take a long time.
>i prefere using sqlserver dts to import datas.
You can "read" your current view definitions via DbGetProp(), ADbObjects() etc., see also gendbc.prg in Vfp's Home()+'tools\gendbc' folder.
And then modify them, insert "Remote Connect" clauses for example, either manually or even programmatically.
At that point, the backend syntax matters so that for example VFP functions like DateTime() or Iif() must be replaced with their equivalents in your particular backend syntax, say "To_Date()" and "Case When" in Oracle.
hth
-Stefan
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