[6.1] Insert Customer record

Yahoo Archive
1
You just need to make sure no-one else has inserted one and gotten the
same custnum.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Luster
Sent: Thursday, December 01, 2005 2:48 PM
To: vantage@yahoogroups.com
Subject: [Vantage][6.1] Insert Customer record

Anyone successfully inserted a record into the customer table?



More so.... Is there a problem with appending numbers into the custnum
field?



Joe Luster

Network Administrator

Cold Jet, LLC

513-831-3211 ext. 308

513-831-1209 FAX



<http://www.coldjet.com>



_____



[Non-text portions of this message have been removed]




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
2
Anyone successfully inserted a record into the customer table?



More so.... Is there a problem with appending numbers into the custnum
field?



Joe Luster

Network Administrator

Cold Jet, LLC

513-831-3211 ext. 308

513-831-1209 FAX



<http://www.coldjet.com>



_____



[Non-text portions of this message have been removed]
3
This sounds like it has oodles of potential to corrupt your database. In particular Custnum is a non-user maintainable field that is assigned sequentially as customers are added for a good reason. It allows you to change the CustID (the user visible version) while maintaining all the linkages to the particular customer from other tables. It is all those links to transactions and other tables that will get seriously messed up if customers are not added and all the database triggers obeyed or if CustNum is altered on the customer table. I would advise sticking to the CustID and ignoring the CustNum field as well as using only the screen interface or a Custom Programming routine to add customers.
-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Joe Luster
Sent: Thursday, December 01, 2005 1:48 PM
To: vantage@yahoogroups.com
Subject: [Vantage][6.1] Insert Customer record


Anyone successfully inserted a record into the customer table?



More so.... Is there a problem with appending numbers into the custnum
field?



Joe Luster

Network Administrator

Cold Jet, LLC

513-831-3211 ext. 308

513-831-1209 FAX



< http://www.coldjet.com>



_____



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links




SPONSORED LINKS
Manufacturing <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
Pda <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software Database <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .


_____




[Non-text portions of this message have been removed]