I am using PHP to add a value to a table. This table has a Client Name, ClientID, and Display field.
The Client Name is just a string entered by the user, and the Client ID is an auto number. The display field is "Client Name - ClientID". Is there anyway to do this in one call? Right now the only way I can think of doing this is to
1. InsertData to add the client
2. SelectData to get the Client ID
3. UpdateData to add the Display field.
Is there anyway to do this in less calls? Can the Autonumber field be used like how it is used in the forms, with [@InsertRecordClientID] being parsed to the number on insert?
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
NarayanJr
I am using PHP to add a value to a table. This table has a Client Name, ClientID, and Display field.
The Client Name is just a string entered by the user, and the Client ID is an auto number. The display field is "Client Name - ClientID". Is there anyway to do this in one call? Right now the only way I can think of doing this is to
1. InsertData to add the client
2. SelectData to get the Client ID
3. UpdateData to add the Display field.
Is there anyway to do this in less calls? Can the Autonumber field be used like how it is used in the forms, with [@InsertRecordClientID] being parsed to the number on insert?
Thank You,
Adam
Link to comment
Share on other sites
0 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.