<html><head></head><body><div class="ydp27062cbeyahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div></div>
<div dir="ltr" data-setdir="false">Me again</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">Thanks to everyone here I've managed to get a semi working program. Just one question. What am I missing in this code? No error is raised yet an item is not deleted? My save instruction and load instructions work fine, but both update and delete don't commit... what am I missing?</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false"><div><div>Public Sub btnDelete_Click()</div><div> </div><div> $Request = "SUPPLIER = &1 AND QUOTE_NO = &2"</div><div> </div><div> Inc Application.Busy</div><div> </div><div> conMod.$Con.Begin()</div><div> </div><div> conMod.$Con.Delete("PREPAIDS", $Request, Trim(cboSupplier.Text), Trim(edtQuoteNo.Text)) 'according to gb.db this is a subroutine, so doesn't return a result?</div><div> conMod.$Con.Commit()</div><div> </div><div> btnClear_Click()</div><div> </div><div>Finally</div><div> Dec Application.Busy</div><div> </div><div>Catch</div><div> conMod.$Con.Rollback()</div><div> objErr.dhError()</div><div> </div><div>End</div></div><div><br></div><div dir="ltr" data-setdir="false"><i>Debug info:</i></div><div dir="ltr" data-setdir="false"><div><div dir="ltr" data-setdir="false"><div><div><i>gb.gui: warning: 'gb.qt5' component not found, using 'gb.qt4' instead</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA empty_result_callbacks = ON</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA full_column_names = ON</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select tbl_name from ( select tbl_name from sqlite_master where type = 'table' union select tbl_name from sqlite_temp_master where t</i></div><div><i>ype = 'table' ) where tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select tbl_name from ( select tbl_name from sqlite_master where type = 'table' union select tbl_name from sqlite_temp_master where t</i></div><div><i>ype = 'table' ) where tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: SELECT COUNT(*) AS nRecord FROM "PREPAIDS"</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select tbl_name from ( select tbl_name from sqlite_master where type = 'table' union select tbl_name from sqlite_temp_master where t</i></div><div><i>ype = 'table' ) where tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: SELECT DISTINCT SUPPLIERNAME FROM SUPPLIER ORDER BY SUPPLIERNAME;</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: SELECT "REF" FROM "PREPAIDS" ORDER BY "REF" LIMIT 256</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: SELECT * FROM "PREPAIDS" ORDER BY "REF" LIMIT 256</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: BEGIN</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: SELECT * FROM "PREPAIDS" WHERE SUPPLIER = 'Flash Components CC' AND QUOTE_NO = '01036848'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: select sql from sqlite_master where type = 'table' and tbl_name = 'PREPAIDS'</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA index_list('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: PRAGMA table_info('PREPAIDS')</i></div><div><i>gb.db.sqlite3: 0x5587541f1018: DELETE FROM "PREPAIDS" WHERE SUPPLIER = 'Flash Components CC' AND QUOTE_NO = '01036848'</i></div><div><i><br></i></div></div><div dir="ltr" data-setdir="false"><i>thx</i></div><div dir="ltr" data-setdir="false"><i><br></i></div><div dir="ltr" data-setdir="false">David</div><br></div></div></div></div>
</div><div id="yahoo_quoted_4182884516" class="yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Friday, May 17, 2019, 09:53:07 AM GMT+2, Gianluigi <bagonergi@gmail.com> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="yiv7033173561"><div><div dir="ltr"><div dir="ltr">Sorry, I would look at the answer 501</div><div dir="ltr"><br clear="none"></div><div>Gianluigi<br clear="none"></div></div><br clear="none"><div class="yiv7033173561gmail_quote"><div class="yiv7033173561gmail_attr" dir="ltr">Il giorno ven 17 mag 2019 alle ore 09:42 Gianluigi <<a rel="nofollow" shape="rect" ymailto="mailto:bagonergi@gmail.com" target="_blank" href="mailto:bagonergi@gmail.com">bagonergi@gmail.com</a>> ha scritto:<br clear="none"></div><div class="yiv7033173561yqt1822149916" id="yiv7033173561yqt88233"><blockquote class="yiv7033173561gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex;"><div dir="ltr"><div dir="ltr">Take look here:<br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="https://askubuntu.com/questions/162391/how-do-i-fix-my-locale-issue/272892#272892">https://askubuntu.com/questions/162391/how-do-i-fix-my-locale-issue/272892#272892</a><br clear="none"><br clear="none">Gianluigi<br clear="none"></div></div><br clear="none"><div class="yiv7033173561gmail_quote"><div class="yiv7033173561gmail_attr" dir="ltr">Il giorno ven 17 mag 2019 alle ore 09:00 David Silverwood via User <<a rel="nofollow" shape="rect" ymailto="mailto:user@lists.gambas-basic.org" target="_blank" href="mailto:user@lists.gambas-basic.org">user@lists.gambas-basic.org</a>> ha scritto:<br clear="none"></div><blockquote class="yiv7033173561gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex;"><div><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpf8708731yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div></div>
<div><div><div>Thanks Gianluigi</div><div><br clear="none"></div><div>The following explains my problem, from your example. Thank you very much!</div><div><br clear="none"></div><div>gbx3: warning: cannot switch to language 'en_ZA</div><div>.UTF-8': No such file or directory. Did you ins</div><div>tall the corresponding locale packages?</div><div><br clear="none"></div><div>Tried it with EN_GB as well and again the same error. I suspect it may be a distro error as gambas probably switches to en_US as default? en_ZA should have installed when I originally installed Mint 18. Seems there is no en_ZA language pack out there ??? Checked the distro. Ah well, back to the drawing board.</div><div><br clear="none"></div><div>Thank you Charlie and Gianluigi, for your patience and your much valued assistance. Really appreciate it!</div><div><br clear="none"></div><div>David</div></div><br clear="none"></div><div><br clear="none"></div>
</div><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byahoo_quoted" id="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byahoo_quoted_8890881488">
<div style="">
<div>
On Thursday, May 16, 2019, 11:35:07 PM GMT+2, Gianluigi <<a rel="nofollow" shape="rect" ymailto="mailto:bagonergi@gmail.com" target="_blank" href="mailto:bagonergi@gmail.com">bagonergi@gmail.com</a>> wrote:
</div>
<div><br clear="none"></div>
<div><br clear="none"></div>
<div><div id="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583"><div><div dir="ltr"><div dir="ltr">Try the attached project</div><div dir="ltr"><br clear="none"></div><div>Regards</div><div>Gianluigi<br clear="none"></div></div><br clear="none"><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail_quote"><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail_attr" dir="ltr">Il giorno gio 16 mag 2019 alle ore 19:45 Gianluigi <<a rel="nofollow" shape="rect" ymailto="mailto:bagonergi@gmail.com" target="_blank" href="mailto:bagonergi@gmail.com">bagonergi@gmail.com</a>> ha scritto:<br clear="none"></div><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583yqt9075310514" id="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583yqt99339"><blockquote class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex;"><div dir="ltr"><div dir="ltr">I'm not talking about using dates like Strings (Cogier) but using dates as Dates.<br clear="none">This was taught to me by Fabien Bodard (here) and Sotema in Italy.<br clear="none">If you always use the Date value for your calculations you will have no problems.<br clear="none">Then when you need to show it to the user use Str or Format.</div><div dir="ltr"><br clear="none"></div><div>Regards</div><div>Gianluigi<br clear="none"></div></div><br clear="none"><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail_quote"><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail_attr" dir="ltr">Il giorno gio 16 mag 2019 alle ore 19:32 Gianluigi <<a rel="nofollow" shape="rect" ymailto="mailto:bagonergi@gmail.com" target="_blank" href="mailto:bagonergi@gmail.com">bagonergi@gmail.com</a>> ha scritto:<br clear="none"></div><blockquote class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex;"><div dir="ltr"><div dir="ltr">You can write the Date value like this:<br clear="none">hResult!usdat = hDate ' ReportTest<br clear="none">And you can read it like this:<br clear="none">Left(Str(hDate), 10) '(international)<br clear="none">Or<br clear="none">Format(hDate, "dd/mm/yyyy") '(Local)</div><div dir="ltr"><br clear="none"></div><div>Regards</div><div>Gianluigi<br clear="none"></div></div><br clear="none"><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail_quote"><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail_attr" dir="ltr">Il giorno gio 16 mag 2019 alle ore 18:48 David Silverwood via User <<a rel="nofollow" shape="rect" ymailto="mailto:user@lists.gambas-basic.org" target="_blank" href="mailto:user@lists.gambas-basic.org">user@lists.gambas-basic.org</a>> ha scritto:<br clear="none"></div><blockquote class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex;"><div><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp93937884yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div></div>
<div>and if I use today's date I get the following error...</div><div><div>
<p style="margin:0px;">'Error 21 in FExpenses.btnLoad_Click.143</p>
<p style="margin:0px;">The following error has occurred:</p>
<div style="margin:0px;">Out of bounds'</div></div><div style="margin:0px;"><br clear="none"></div><div style="margin:0px;">I think its stating that the month cannot be 16 and therefore out of bounds because I do not get this error when I use say 2019-05-05/ 2019-09-12 etc. As I said, my textbox swops the month and day around.</div><div style="margin:0px;"><br clear="none"></div><div style="margin:0px;">Please bear with me. I am currently learning Gambas.</div><br clear="none"></div><div><br clear="none"></div>
</div><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yahoo_quoted" id="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yahoo_quoted_8935663322">
<div>
<div>
On Thursday, May 16, 2019, 6:40:08 PM GMT+2, David Silverwood via User <<a rel="nofollow" shape="rect" ymailto="mailto:user@lists.gambas-basic.org" target="_blank" href="mailto:user@lists.gambas-basic.org">user@lists.gambas-basic.org</a>> wrote:
</div>
<div><br clear="none"></div>
<div><br clear="none"></div>
<div><div id="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788"><div><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydpdd45f520yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div></div>
<div>To add</div><div><br clear="none"></div><div>if I do this, which I have also tried, it comes close but still swops the month and day around...</div><div><br clear="none"></div><div><div><div> If edtDate.Text Then</div><div> sDate = Left$(edtDate.Text, 10)</div><div> $Date = Split(sDate, "/")</div><div> Debug sDate = $Date[2] & "-" & $Date[1] & "-" & $Date[0]</div><div> edtDate.Text = sDate</div><div> Endif</div></div><br clear="none"></div><div>Changing $Date[1] and $Date[0] around makes no difference whatsoever</div><div><br clear="none"></div><div>Regards</div><div><br clear="none"></div><div>David</div><div><br clear="none"></div>
</div><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yahoo_quoted" id="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yahoo_quoted_8781085714">
<div>
<div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788yqt5179636273" id="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788yqt11540"><div>
On Thursday, May 16, 2019, 6:31:07 PM GMT+2, David Silverwood via User <<a rel="nofollow" shape="rect" ymailto="mailto:user@lists.gambas-basic.org" target="_blank" href="mailto:user@lists.gambas-basic.org">user@lists.gambas-basic.org</a>> wrote:
</div>
<div><br clear="none"></div>
<div><br clear="none"></div>
<div><div id="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808"><div><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp2d98c143yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div></div>
<div>Hi Gianluigi</div><div><br clear="none"></div><div>Are you referring to this portion:</div><div><div><div> Randomize</div><div> $hConn.Begin()</div><div> For i = 0 To $nRecords</div><div> nCasual = Rand(0, 30)</div><div> sName = aFirstName[nCasual]</div><div> nCasual = Rand(0, 30)</div><div> sSurname = aLastName[nCasual]</div><div> y = Rand(1959, 2000)</div><div> m = Rand(1, 12)</div><div> d = Rand(1, 28)</div><div> hDate = Date(y, m, d)</div><div> hResult = $hConn.Create("tuser")</div><div> hResult!usnam = sName</div><div> hResult!ussur = sSurname</div><div> hResult!usdat = hDate</div><div> hResult.Update</div><div> Next</div></div><br clear="none"></div><div>I actually found the code difficult to decipher but looking at it again I assume you are referring to hDate = Date(y, m, d)?</div><div><br clear="none"></div><div><br clear="none"></div><div><br clear="none"></div>
</div><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yahoo_quoted" id="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yahoo_quoted_8936458258">
<div>
<div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808yqt5353588679" id="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808yqt00136"><div>
On Thursday, May 16, 2019, 6:25:09 PM GMT+2, Gianluigi <<a rel="nofollow" shape="rect" ymailto="mailto:bagonergi@gmail.com" target="_blank" href="mailto:bagonergi@gmail.com">bagonergi@gmail.com</a>> wrote:
</div>
<div><br clear="none"></div>
<div><br clear="none"></div>
<div><div id="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451"><div><div dir="ltr"><div dir="ltr"><div dir="ltr">I had shown you the correct code you need to look at in Report1.</div><div dir="ltr"><br clear="none"></div><div>Regards</div><div>Gianluigi<br clear="none"></div><br clear="none"><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail_quote"><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451yqt9809881283" id="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451yqtfd95352"><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail_attr" dir="ltr">Il giorno gio 16 mag 2019 alle ore 16:17 David Silverwood via User <<a rel="nofollow" shape="rect" ymailto="mailto:user@lists.gambas-basic.org" target="_blank" href="mailto:user@lists.gambas-basic.org">user@lists.gambas-basic.org</a>> ha scritto:<br clear="none"></div><blockquote class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex;"><div><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail-m_-4058040158495589322ydp6791a4fdyahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div></div>
<div>Ok, so I'm back with the same problem. It seems to me Gambas has a template format for a date and trying to change it is impossible? As soon as Gambas sees it as a date, it reformats my formatting back to the incorrect format and renders all the code useless. Is this the way it is supposed to be? </div><div><br clear="none"></div><div>I need my date formatted to sqlite format, eg, yyyy-mm-dd</div><div><br clear="none"></div><div>However, soon as I do that, gambas switches it to mm/dd/yyyy.</div><div><br clear="none"></div><div>My OS regional settings are correct. Using Mint 18.3 KDE and Gambas 3.13 (Thanks Charlie for the upgrade tip)</div><div><br clear="none"></div><div>The latter format is useless over here and inevitably gambas reads the day and month wrong, by switching it... I've tried using Split and in a debug /print statement I see that it does do exactly what I need, but once the format hits the textbox, Gambas actually changes it back to mm/dd/yyyy. How do I stop that? I tried DIM'ing the dates as Strings but Gambas seems to read dates as dates even if they are dimensioned as strings? (which I know they are 'special' strings of course).</div><div><br clear="none"></div><div>My sqlite3 database complains whenever I try and save the dates in Gambas's preferred format.</div><div><br clear="none"></div><div>I know I am doing something wrong since no one else has this issue.... but what?</div><div><br clear="none"></div><div><br clear="none"></div><div><br clear="none"></div>
</div><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail-m_-4058040158495589322ydpe15f8925yahoo_quoted" id="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail-m_-4058040158495589322ydpe15f8925yahoo_quoted_8492039099">
<div>
<div>
On Tuesday, April 30, 2019, 11:05:06 AM GMT+2, David Silverwood via User <<a rel="nofollow" shape="rect" ymailto="mailto:user@lists.gambas-basic.org" target="_blank" href="mailto:user@lists.gambas-basic.org">user@lists.gambas-basic.org</a>> wrote:
</div>
<div><br clear="none"></div>
<div><br clear="none"></div>
<div><div id="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail-m_-4058040158495589322ydpe15f8925yiv7748707307"><div><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail-m_-4058040158495589322ydpe15f8925yiv7748707307ydp65c9a003yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div></div>
<div>Thank you very much Charlie and Gianluigi. Those were pointers in the right direction for me! I really appreciate your help. (Not to mention I just learned a lot from both of your code too.)</div><div><br clear="none"></div></div></div></div></div></div></div></div></blockquote></div></div></div></div></div></div><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yqt9809881283" id="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yqtfd17783"><br clear="none">----[ Gambas mailing-list is hosted by <a rel="nofollow" shape="rect" target="_blank" href="https://www.hostsharing.net">https://www.hostsharing.net </a>]----<br clear="none"></div></div></div>
</div>
</div></div></div><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yqt5353588679" id="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yqt46446"><br clear="none">----[ Gambas mailing-list is hosted by <a rel="nofollow" shape="rect" target="_blank" href="https://www.hostsharing.net">https://www.hostsharing.net </a>]----<br clear="none"></div></div></div>
</div>
</div></div></div><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yqt5179636273" id="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byiv3967838583gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yqt89443"><br clear="none">----[ Gambas mailing-list is hosted by <a rel="nofollow" shape="rect" target="_blank" href="https://www.hostsharing.net">https://www.hostsharing.net </a>]----<br clear="none"></div></div>
</div>
</div></div><br clear="none">
----[ Gambas mailing-list is hosted by <a rel="nofollow" shape="rect" target="_blank" href="https://www.hostsharing.net">https://www.hostsharing.net</a> ]----<br clear="none">
</blockquote></div>
</blockquote></div>
</blockquote></div></div></div></div><div class="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byqt9075310514" id="yiv7033173561gmail-m_2095791589728543325gmail-m_-8739515737632891838ydpe716724byqt67179"><br clear="none">----[ Gambas mailing-list is hosted by <a rel="nofollow" shape="rect" target="_blank" href="https://www.hostsharing.net">https://www.hostsharing.net </a>]----<br clear="none"></div></div>
</div>
</div></div><br clear="none">
----[ Gambas mailing-list is hosted by <a rel="nofollow" shape="rect" target="_blank" href="https://www.hostsharing.net">https://www.hostsharing.net</a> ]----<br clear="none">
</blockquote></div>
</blockquote></div></div></div></div><div class="yqt1822149916" id="yqt19520"><br clear="none">----[ Gambas mailing-list is hosted by <a shape="rect" href="https://www.hostsharing.net " target="_blank">https://www.hostsharing.net </a>]----<br clear="none"></div></div>
</div>
</div></body></html>