'd' bug

[kokenge]

RunBasic beta and beta 2.
Some fields have a 'd' after them when displaying data. I've had it happen on double and floating fields from a SQLite DB.

This only happens if the field is 0.

[meerkat]

Still a problem with the latest release.
Looks like it only happens when the field is zero or null.

[Carl Gundel - admin]

Dec 14, 2008 5:04:09 GMT -5 meerkat said:

Still a problem with the latest release.
Looks like it only happens when the field is zero or null.

Do you have a small example program?

-Carl

[meerkat]

Here is a example.
Check the printout..

Hope this helps..

NullColumn$	= ""
sqliteconnect #sql, ":memory:"
mem$ = "CREATE TABLE member ( memberNum INT(10), _
memberType CHAR(2), billShipSw CHAR(1), firstName VARCHAR(22), _
middleName VARCHAR(22), lastName VARCHAR(22), addr1 VARCHAR(22), _
addr2 VARCHAR(22), city VARCHAR(22), state CHAR(3), _
zip VARCHAR(10), country VARCHAR(4), phone VARCHAR(17), _
eMail VARCHAR(40), rqstNews CHAR , rqstPromo CHAR , _
rqstNew CHAR , lastVistiDate DATETIME, lastOrderDate DATETIME, _
totOrderAmt FLOAT, numOrders SMALLINT, ip VARCHAR(16), _
username VARCHAR(16), password VARCHAR(16), _
passwordHint VARCHAR(50) )"
#sql execute(mem$)
mem$ = "INSERT INTO member VALUES _
('1', 'D', 'B', 'Bobby', 'Back', 'Breaker', 'I have no address', _
NULL, 'Anderson', 'CA', '96001', 'USA', '111-222-3333', _
NULL, 'N', 'N', 'N', '2008-12-02', '2008-12-13', '0.0', '0', _
NULL, 'admin', 'admin', 'What is Kashogi')"
#sql execute(mem$)
mem$ = "INSERT INTO member VALUES _
('3', 'G', 'B', 'George', 'G', 'Gasher', 'Sea Shell', _
NULL, 'Portland', 'OR', '97105', 'USA', NULL, NULL, 'N', 'N', 'N', _
NULL, NULL, '0.0', '0', NULL, 'demo', 'demo', NULL)"
#sql execute(mem$)
mem$ = "INSERT INTO member VALUES _
('1', 'D', 'S', 'Bobby', 'Back', 'Breaker', 'Ship Addr1', 'Ship Addr2', _
'Ship City', 'CA', '96001', 'USA', '111-222-3333', _
NULL, 'N', 'N', 'N', '2008-12-02', '2008-12-13', '0.0', '0', _
NULL, 'admin', 'admin', 'What is Kashogi')"
#sql execute(mem$)
mem$ = "INSERT INTO member VALUES _
('3', 'G', 'S', 'George', 'G', 'Gasher', 'Ship Addr1', 'Ship Addr2', _
'Ship City', 'OR', '97105', 'USA', NULL, NULL, 'N', 'N', 'N', NULL, _
NULL, '0.0', '0', NULL, 'demo', 'demo', NULL)"
#sql execute(mem$)

 sql$    = "SELECT * FROM member" 
 #sql	execute(sql$)
 WHILE    #sql hasanswer()
 #row = #sql #nextrow()
	memberNum$	= #row memberNum$()
	memberNum	= #row memberNum()
	memberType$	= #row memberType$()
	billShipSw$	= #row billShipSw$()
	firstName$	= #row firstName$()
	middleName$	= #row middleName$()
	lastName$	= #row lastName$()
	addr1$		= #row addr1$()
	addr2$		= #row addr2$()
	city$		= #row city$()
	state$		= #row state$()
	zip$		= #row zip$()
	country$	= #row country$()
	phone$		= #row phone$()
	eMail$		= #row eMail$()
	rqstNews$	= #row rqstNews$()
	rqstPromo$	= #row rqstPromo$()
	rqstNew$	= #row rqstNew$()
	lastVistiDate$	= #row lastVistiDate$()
	lastOrderDate$	= #row lastOrderDate$()
	totOrderAmt$	= #row totOrderAmt$()
	totOrderAmt	= #row totOrderAmt()
	numOrders$	= #row numOrders$()
	numOrders	= #row numOrders()
	ip$		= #row ip$()
	username$	= #row username$()
	password$	= #row password$()
	passwordHint$	= #row passwordHint$()

html memberNum;" ";totOrderAmt;"<BR>"
wend

wait

[Carl Gundel - admin]

Okay, this is fixed for the next release.

Thanks!

-Carl