richard, i have not looked into lsmb's schema but in the ole sl schema partnumber isn't unique so in the long run it would be a better idea to use id instead of partnumber in your where clause. we have thousands of partnumber coming from different suppliers and the only way we are able to check for unique partnumber amongst the different suppliers was to built a unique index on partnumber. however, lsmb's schema change may have taken care of this issue.
regards, tim > Hi All, > I'm trying to get to grips with SQL (who knows, I may even produce > something worthwhile for the project!) only having some very basic > knowledge. I'm using phppgadmin for SQL type things. > > A weekly task is updating prices. So far I've got > > UPDATE parts > SET sellprice = 0.34, listprice = 0.34 > WHERE partnumber = '7316' > > which is fine, but how do I read a CSV file in? All the examples I've > found on the web seem to just "assume" that bit! > > Thanks in advance. > > Richard > > By the by, day one of going live with LSMB went well! > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > Don't miss this year's exciting event. There's still time to save $100. > Use priority code J8TL2D2. > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone > _______________________________________________ > Ledger-smb-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
