posted 22 years ago
"INSERT INTO dbo.PCVENDX ( PCVNO, PCVNM, PCVA1, PCVA2, PCVCT, PCVST, PCVZ5, PCVCT1, PCVPH1, PCVCT2, PCVPH2, PCVTRM, PCVMIN, PCVCM1, PCVCM2, PCVRTG, PCVFTM, PCVLTL, PCVLTM, PCVSK, PCVPH3, PCVOUT, PCVEML ) VALUES ( :VNUM, :VNAM, :VADDR1, :VADDR2, :VCITY, :VSTAT, :VZIP, :CTC1, :PHN1, :CTC2, :PHN2, :TRMS, :MORD, :COMM1, :COMM2, :TRUCK, :TRTYP, :LTLCAR, :LTLTYP, :SKAP, :FAXN, :OUTC, :VEML )";
"UPDATE dbo.PCVENDX SET PCVNO = :VNUM, PCVNM = :VNAM, PCVA1 = :VADDR1, PCVA2 = :VADDR2, PCVCT = :VCITY, PCVST = :VSTAT, PCVZ5 = :VZIP, PCVCT1 = :CTC1, PCVPH1 = :PHN1, PCVCT2 = :CTC2, PCVPH2 = :PHN2, PCVTRM = :TRMS, PCVMIN = :MORD, PCVCM1 = :COMM1, PCVCM2 = :COMM2, PCVRTG = :TRUCK, PCVFTM = :TRTYP, PCVLTL = :LTLCAR, PCVLTM = :LTLTYP, PCVSK = :SKAP, PCVPH3 = :FAXN, PCVOUT = :OUTC, PCVEML = :VEML WHERE ( ( dbo.PCVENDX.PCVNO = :VNDNO ) )";
Just a note: These statements were generated by the SQL Assist SmartGuide.
Thanks!