Re: Not Strictly LSMB but....

[..hidden..]

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
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>