 sql file Posts
"sql file" Message Board Posts |
Thread 3 of 3 | 
PS_383 |  pass parameter to paradox sql fileIs there a way to pass parameter to paradox sql file? Something like:, , Update Table1 Set CurrentDate = ?, Update Table1 Set CurrentDate = :CurrentDate, Update Table1 Set CurrentDate = @CurrentDate, , All I found is this article:, https://stackoverflow.com/questions/12416503/delphi-query-parameter-usage-when-all-values-is-also-an-option
| 1 Reply: | 
Steven.G | sorry, haven't touched the sql stuff within paradox in a long time
|
| 
 1276
Hits | |
Thread 2 of 3 |
brent | s.o.s! hi all.i;m quite new to this boards.and i hope somebody will give a little favour for me., , i'm using ms sql server2000 for my project.tragically,my os(winxp) broke down., i'm worried bout all the data inside., can i just save these data,reinstall mssql server and then copy back all the old file with the precious data into the new file?, , and i wanna know if i can do just like that.actually where's my old data(databases,tables,stored procedures) are in the sql file?is it in the Binn file., , i appreciate any help from all of you.thanx |
3215
Hits | |
Thread 1 of 3 | 
Zonetrap | Opening a SQL File with a Button I'm having trouble opening a SQL file with a button. I know the code below runs the query, but all I want to do is open it up, so I can change some of the criteria. Does anyone know what I can do here? , Thanks, , method pushButton(var eventInfo Event), var , q Query , tv TableView , endVar , q.readFromFile("J:\\MDRDatabase\\Users_List\\Users_List") , , q.executeQBE(":WORK:answer.db") , ;// run the query , , tv.open(":WORK:answer.db") , ;// display the results , , endMethod
| 3 replies. Last post: | 
dhfast | Using Paradox as an ole automation server works. If your sql file is c:\queries\myquery.sql, then this could be the code:, , method pushButton(var eventInfo Event), var ol oleauto endvar, ol.open("Paradox.Application"), ol.sqlquerydesign("c:\\queries\\myquery.sql"), ol.close(), endMethod, , For qbe files, the command would be querydesign instead of sqlquerydesign. |
|
3031
Hits | |
"sql file" Knowledge Base Posts |
| |
KB Article |
|
|
Mike Prestwood
|
1. Perl Development Tools
Many developers just use a text editor but you have to be careful when developing on Windows and deploying to Unix/Linix. Some Windows text editors including Notepad, and Microsoft Expression Web save text files in UTF-8 which is not compatible with Unix/Linux.
There are many Perl editors available including ActivePerl Pro Studio, and the free Perl Express. I usually use Perl Express.
Quick Start: Install Perl to IIS or Apache, install Perl Express then configure to use Perl, then install MySQL. For IIS 7, you will likely have to configure Hangler Mappings and add %s %s.
18 years ago, and updated 17 years ago
|
 Code 16108
Hits
|
Perl
|
Mike Prestwood
|
2. Use an Alias to Refer to Your Paradox Tables
Put your tables in a directory different from the one that contains the forms, reports, and libraries. Use an alias to refer to the tables. This makes your application instantly a network-compatible application by making the tables relocatable. When you install the application onsite, you simply have to ask where to put the data and where to put the application. The application can be local or on the network. Place the data files where they need to be, and change the alias path. If you eventually want to move your data onto a SQL server, then you will have less code to rewrite.
19 years ago, and updated 18 years ago
|
 Tip 10098
Hits
|
Corel Paradox / ObjectPAL Coding
|
|
Print This