Rob
|
Posted: 06/12/2001, 1:04 PM |
|
Sorry I am novice SQL/ CodeCharge user. I want to display an order status
and in my Customer Table, I have 1- 3 delivery addresses of same Customer
(field CUSN03) and in one field called DSEQ03 which specify delivery code.
So my governing key for Customer address is CUSN03 and DSEQ03. I assume that
first delivery address of Customer is customer's main address and I want to
display this as header on my Order Tacking Page so that if customer want to
check order status, he shall see his main address as header. Now question is
how I make an SQL statement that says to select first row of CUSN03 with
respect to DSEQ03.
I hope I am able to explain my problem. Any suggestion for SQL statement
would be highly appreciated. Perhaps CodeCharge Support can help as they did
make a pilot profile for me.
Rob
|
|
|
CodeCharge
|
Posted: 06/12/2001, 4:01 PM |
|
You can add "DSEQ03" as a parameter in the Input section of your form.
CodeCharge will automatically create proper SQL query.
"Rob" <rob@rhct.net> wrote in messagenews:9g5sjl$s3v$1@mail.tankhill.com...
> Sorry I am novice SQL/ CodeCharge user. I want to display an order status
> and in my Customer Table, I have 1- 3 delivery addresses of same Customer
> (field CUSN03) and in one field called DSEQ03 which specify delivery
code.
> So my governing key for Customer address is CUSN03 and DSEQ03. I assume
that
> first delivery address of Customer is customer's main address and I want
to
> display this as header on my Order Tacking Page so that if customer want
to
> check order status, he shall see his main address as header. Now question
is
> how I make an SQL statement that says to select first row of CUSN03 with
> respect to DSEQ03.
>
> I hope I am able to explain my problem. Any suggestion for SQL statement
> would be highly appreciated. Perhaps CodeCharge Support can help as they
did
> make a pilot profile for me.
>
> Rob
>
>
>
|
|
|
|