I've come to realize that PL/SQL is exlusive to Oracle. That doesn't help me for what I need to do. I'm writing a program that populates a flexgrid using data it receives from and ACCESS database.
My problem is that I need to use some IF/THEN/ELSE and counter assigning logic in one of my SQL queries.
Is this possible? I know you can set up all kinds of queries, but can you use the kind of logic in an SQL statement in VB when talking to ACCESS. If so, a small example of IF/THEN/ELSE and counter logic would be greatly appreciated.
Thanks...
My problem is that I need to use some IF/THEN/ELSE and counter assigning logic in one of my SQL queries.
Is this possible? I know you can set up all kinds of queries, but can you use the kind of logic in an SQL statement in VB when talking to ACCESS. If so, a small example of IF/THEN/ELSE and counter logic would be greatly appreciated.
Thanks...