Full-Path vs FileName - I am confused

[sundale]

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

    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()