soonhuat ong wrote: > CREATE TABLE STOCKTBL ( > STOCKID VARCHAR(20) NOT NULL, > UNITCOST DOUBLE PRECISION DEFAULT 0.00, > CONSTRAINT PKEY_STOCK PRIMARY KEY (STOCKID)); > > When i try to insert a record into the STOCKTBL,
How do you do that? > it seems like UnitCost field can't enter properly. It "seems"? What actually happens? Do you get an exception? Is the exception from the database, from IBX, from the BDE? Does your data silently get converted to something else? > What i mean is that UnitCost field doesn't allows dot '.' as decimal point. The UnitCost field doesn't allow text at all. Its type is Double Precision. It shouldn't care how the value is represented as text since it should never be transmitted as text in the first place. -- Rob ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/i7folB/TM --------------------------------------------------------------------~-> ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
