Create/Add new customer via SQL/COM

Apr 23, 2008 2 Replies

I need to be able to create a new customer account via code/SQL. I'm trying to find out if there's a QSRules property/method that will do it (I don't think so), and if not, what are the tables besides Customer that get records created at the same time?



Obviously, it depends on what info is provided but is there a set of tables that get touched by default? Or is it safe to just add a record to Customer and then go from there?



Alternatively, is there a way to "call" whatever gets called when you click on "New" from the "Find" window under "Set customer"?



Much thanks,



Dann


I'd be very interested in an answer to this also!

If you have any info on using qsrules effectively i would appreciate an email! Regards Rob

you can create via sql or via QSRules new customers.. but the account number isn't a progressive number....

you can add a customer also using the statement

INSERT INTO [Customer] (AccountNumber) VALUES('YourAccount');

cod

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required