Post by sundale on Feb 7, 2010 11:32:30 GMT -5
In connection to my previous post, "Full-Path vs FileName - sqlite returns different", I am confused by seeing another happening.
I didn't modify the database, but read from my program only.
Now, today, the database can be read by "File Name ONLY" too.
Then, the full-path file name cannot read one of the record while file-name only can read them all.
From the display result, in full-path reading, "opt" record has key but no data.
While file-name-only show the full content of the record with the key "opt".
???WHY - If anyone know when this things can be happen, please help.
THANKS.
-sundale
Exit full screen mode
filename=f:\RunBasic\public\orm\Project\Project001-39835.orm
type name tbl_name rootpage
table invoices invoices 2
index sqlite_autoindex_invoices_1 invoices 3
table invoiceopt invoiceopt 4
table fisher fisher 5
index sqlite_autoindex_fisher_1 fisher 6
============================== RENDER THE DATABASE invoiceopt
code content
opt
sum List Price Total = $10,423.35\Chargable Amount = $8,547.45\Discount Amount = $1,875.90 (18.00%)\Cost Amount = $7,129.75
sum2 10423.35\8547.45\1875.9\7129.75
shop TSS\SM\CSH\\CASH
Inform Database name
filename=Project001-39835.orm
type name tbl_name rootpage
table invoices invoices 2
index sqlite_autoindex_invoices_1 invoices 3
table invoiceopt invoiceopt 4
table fisher fisher 5
index sqlite_autoindex_fisher_1 fisher 6
============================== RENDER THE DATABASE invoiceopt
code content
opt The Marine Corp\Agent Name\Project\001\10-01-23\1.4\Provision\B Price\1\황수연
sum List Price Total = $10,423.35\Chargable Amount = $8,547.45\Discount Amount = $1,875.90 (18.00%)\Cost Amount = $7,129.75
sum2 10423.35\8547.45\1875.9\7129.75
shop TSS\SM\CSH\\CASH
I didn't modify the database, but read from my program only.
Now, today, the database can be read by "File Name ONLY" too.
Then, the full-path file name cannot read one of the record while file-name only can read them all.
From the display result, in full-path reading, "opt" record has key but no data.
While file-name-only show the full content of the record with the key "opt".
???WHY - If anyone know when this things can be happen, please help.
THANKS.
-sundale
Exit full screen mode
filename=f:\RunBasic\public\orm\Project\Project001-39835.orm
type name tbl_name rootpage
table invoices invoices 2
index sqlite_autoindex_invoices_1 invoices 3
table invoiceopt invoiceopt 4
table fisher fisher 5
index sqlite_autoindex_fisher_1 fisher 6
============================== RENDER THE DATABASE invoiceopt
code content
opt
sum List Price Total = $10,423.35\Chargable Amount = $8,547.45\Discount Amount = $1,875.90 (18.00%)\Cost Amount = $7,129.75
sum2 10423.35\8547.45\1875.9\7129.75
shop TSS\SM\CSH\\CASH
Inform Database name
filename=Project001-39835.orm
type name tbl_name rootpage
table invoices invoices 2
index sqlite_autoindex_invoices_1 invoices 3
table invoiceopt invoiceopt 4
table fisher fisher 5
index sqlite_autoindex_fisher_1 fisher 6
============================== RENDER THE DATABASE invoiceopt
code content
opt The Marine Corp\Agent Name\Project\001\10-01-23\1.4\Provision\B Price\1\황수연
sum List Price Total = $10,423.35\Chargable Amount = $8,547.45\Discount Amount = $1,875.90 (18.00%)\Cost Amount = $7,129.75
sum2 10423.35\8547.45\1875.9\7129.75
shop TSS\SM\CSH\\CASH
cssClass "table", "{ text-align:left; border-style:solid; border-width:1px; border-color:#000000;}"
cssClass "tr", "{ background:#FFFACD; padding:3px }"
global #invdb, invfile$, invdata$
invfile$ = "f:\RunBasic\public\orm\Project\Project001-39835.orm"
print "filename=";invfile$
sqliteconnect #invdb, invfile$
#invdb execute("SELECT type,name,tbl_name,rootpage FROM sqlite_master")
if #invdb hasanswer() then
render #invdb
end if
print: print: print "============================== RENDER THE DATABASE invoiceopt"
#invdb execute("SELECT * FROM invoiceopt")
if #invdb hasanswer() then
render #invdb
end if
#invdb disconnect()
html "<hr>"
print "Inform Database name";
html "<input type='file' id='file' name ='file' value='c:\rbp101b3\public\SQLite.db' />"
button #a,"Confirm",[dbase]: print
wait
[dbase]
print: print: print
dbase$ = #request get$("file")
print "filename=";dbase$
sqliteconnect #sql,dbase$
#sql execute("SELECT type,name,tbl_name,rootpage FROM sqlite_master")
if #sql hasanswer() then
render #sql
end if
print: print: print "============================== RENDER THE DATABASE invoiceopt"
#sql execute("SELECT * FROM invoiceopt")
if #sql hasanswer() then
render #sql
end if
#sql disconnect()