Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 4 of 4 total |
Same SQL for remote and local? |
Fri, Feb 10 2006 4:34 AM | Permanent Link |
Paul Harrison | Hi
I have an app that is used by many clients with and without the server dependant on the clients preference. The application has multiple databases and I currently have to alter the syntax of the sql to accomodate the differences of the remote and local restrictions. Locally select * from "c:\dbdir1\mytable1" select * from "c:\dbdir2\mytable2" Remote - obviously where DB1 and DB2 are TDBISAMDatabases select * from "\DB1\mytable1" select * from "\DB2\mytable2" Am I missing a trick or am I stuck with two versions of the SQL Thanks in advance Paul D7 & v4.21 |
Fri, Feb 10 2006 1:22 PM | Permanent Link |
"Donat Hebert \(WSI\)" | Hi Paul. We manage our environments though a Function that dynamically
calculates the path based on customers configuration and where they are. You'll find that even temporary workspace can be tricky especially with citrix. Our process uses an alias for databases and diskspace. So when the code fires, it will dynamically adjust based on their own configuration. ie CAlias('DB1','MyTable1',G_UserID) will return ansiquoted Path and tablename glued together ... More complex ones are a users own workspace which can resolve unique space by person to ensure no file collisions. ie G_UserID is current userid for example. You can customize to your needs. There are so many possible variations. Donat. "Paul Harrison" <paul.harrison@ba.com> wrote in message news:216307D7-72CF-4058-B043-E81216BD3FE2@news.elevatesoft.com... > Hi > > I have an app that is used by many clients with and without the server > dependant on the clients preference. > > The application has multiple databases and I currently have to alter the > syntax of the sql to accomodate the differences of the remote > and local restrictions. > > Locally > select * from "c:\dbdir1\mytable1" > select * from "c:\dbdir2\mytable2" > > Remote - obviously where DB1 and DB2 are TDBISAMDatabases > select * from "\DB1\mytable1" > select * from "\DB2\mytable2" > > > Am I missing a trick or am I stuck with two versions of the SQL > > Thanks in advance > > Paul > > D7 & v4.21 > |
Fri, Feb 10 2006 2:42 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Paul,
<< Am I missing a trick or am I stuck with two versions of the SQL >> For now, unfortunately yes. However, the next version (ElevateDB) removes this issue and local and C/S databases are referenced in an identical fashion. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Feb 14 2006 5:35 AM | Permanent Link |
Paul Harrison | Thanks for the info.
Just as I suspected Paul |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |