Very Computer

Hello,

I would appreciate any help about query strings and tilde variables in paradox
for windows (v. 5.0)

I wonder if the is any way to write the following query as a query string:

myQBE = Query

c:\station.db | ID      | LAT                      |  LON                    |
                     | _id    | Check >=~a,<=~b  | Check >=~c,<=~d  |

c:\hydro.db  | ID      | DEPTH   | PO4P    |  TOTP  |
                    | _id    |  Check    |  Check  | Check  |

ENDQUERY

I thank you in advance.

Miguel Rodriguez  Medina

Save this query and look at the file it creates with a text editor.  
Copy it into you objectpal code.  Hope this is what you needed to know.
--

Dana Scott Kaufman

----------------------------------------------------------------------
DDDDD    SSSSSS  K    K              
D    D   S       K   K
D     D  S       K  K
D     D  SSSSSS  KKK     Technologies Inc.
D     D       S  K  K
D    D        S  K   K   Excellence in Paradox
DDDDD    SSSSSS  K    K      Developement
-----------------------------------------------------------------------

CompuServe: 75240,1376
Delphi:     dsktech
See the "DSK Technologies Support" Area in the Paradox forum
  on Delphi (GO CUS 320)

Quote:>Hello,

>I would appreciate any help about query strings and tilde variables in paradox
>for windows (v. 5.0)

>I wonder if the is any way to write the following query as a query string:

>myQBE = Query

>c:\station.db | ID      | LAT                      |  LON                    |
>                     | _id    | Check >=~a,<=~b  | Check >=~c,<=~d  |

>c:\hydro.db  | ID      | DEPTH   | PO4P    |  TOTP  |
>                    | _id    |  Check    |  Check  | Check  |

>ENDQUERY

>I thank you in advance.

>Miguel Rodriguez  Medina

strMyQBE =
"Query\n"+
"\n"+
"c:\\station.db | ID  | LAT                                  | LON                                  |\n"+
"               | _id | Check >="+String(a)+",<="+String(b)+"| Check >="+String(c)+",<="+String(d)+"|\n"+
"\n"+
"c:\\hydro.db  | ID  | DEPTH | PO4P  | TOTP  |\n"+
"              | _id | Check | Check | Check |\n"+
"\n"+
"ENDQUERY"

Don't forget the double "\\" in the table names and the blank lines: "\n"

/*
 * Andreas Rotterdam
 * Westfaelische Wilhelms-Universitaet Muenster
 * Institut fuer Agrarinformatik                Tel: 02 51/29 75 66


 */