Translation of sql commands from ansi to paradox

[Bubsi]

Does somebody knows links, data, or something else where the ansi sql commands are translated in paradox sql commands.

Example: what’s the paradox command for the ansi command "rownum" ?

Thanks for your help

 

[TonyMcGuire]

Probably a translation in the wrong direction, but have you tried the 'local sql help'?

Found in your BDE directory. localsql.hlp on my system.

Tony McGuire
Stop Rob Bennett -

http://www.notrob.info

"It's not about having enough time; we have the rest of our lives. It's about priorities.

 

[Bubsi]

Thanks Tony,

the in the localsql.hlp i found a lot of informations.
But I found nothing for the rownum command.
Is there another possibility to give me a counting number back ?
Example:

Counting_Number Name Adress
1 Peter Street 1
2 Mike Blvd. 2
3 Rosi Street 5678