• Welcome, Guest. Please login.
 
September 17, 2019, 02:40:17 pm

News:

Welcome to the SQLitening support forums!


Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Topics - Fredrick Ughimi

61
Hello,

I' d like use slCopyDatabase to backup my database automatically, say every five 5 minutes. At the moment I only provided manual backup of the database.

Any ideas?
62
Hello,

Is there any one using SQLitening with MLG? I am thinking of changing from Listview to MLG. I don't even know if I should.

Wonder what advantage(s) MLG has over Listview.

I would appreciate your contributions.

Kind regards,
63
Hello,

I have been using yyyy-MM-dd format to store date in SQLite DB. I know its the preferred format. Now, some of my clients said they 'd rather have it in dd-MM-yyyy format (we are used to dd-MM-yyyy date format in this part of my world).

My question is that, it is ok to store date in dd-MM-yyyy format in SQLite DB without having records retrieval problems based on date?

Kind regards,
64
Hello,

A field value was entered as SA
65
Hello, how does one use the JULIANDAY or STRFTIME functions in SQLitening? I get missing declaration error. Best regards
66
Hello,

I have a table of 220 fields. I'm having problems with my save routine as shown below. I get error - STATEMENT TOO LONG/COMPLEX. How can I deal with this?

Any suggestion would be appreciated.



slExe "Begin Immediate"

          Errorcode& = slExe(slBuildInsertOrUpdate("tblChemicalPathologyRoutine", sHospitalNo & $Nul & sLabNo _
             & $Nul & sDate & $Nul & sTime & $Nul & sComments & $Nul & sDetails & $Nul & sCollectionTime _
             & $Nul & sCollectionDate & $Nul & Format$(Abs(lSodium)) & $Nul & sDrName & $Nul & sSodiumRange _
             & $Nul & sSodium & $Nul & sSodiumUnit & $Nul & Format$(Abs(lPotasium)) & $Nul & sPotasiumRange _
             & $Nul & sPotasium & $Nul & sPotasiumUnit & $Nul & Format$(Abs(lChloride)) & $Nul & sChlorideRange _
             & $Nul & sChloride & $Nul & sChlorideUnit & $Nul & Format$(Abs(lBicarbonate)) & $Nul & sBicarbonateRange _
             & $Nul & sBicarbonate & $Nul & sBicarbonateUnit & $Nul & Format$(Abs(lLithium)) & $Nul & sLithiumRange _
             & $Nul & sLithium & $Nul & sLithiumUnit & $Nul & Format$(Abs(lUrea)) & $Nul & sUreaRange & $Nul & sUrea _
             & $Nul & sUreaUnit & $Nul & Format$(Abs(lUricAcid)) & $Nul & sUricAcidRange & $Nul & sUricAcid _
             & $Nul & sUricAcidUnit & $Nul & Format$(Abs(lCreatinine)) & $Nul & sCreatinineRange & $Nul & sCreatinine _
             & $Nul & sCreatinineUnit & $Nul & Format$(Abs(lTotalCalcium)) & $Nul & sTotalCalciumRange _
             & $Nul & sTotalCalcium & $Nul & sTotalCalciumUnit & $Nul & Format$(Abs(lIonisedCalcium)) _
             & $Nul & sIonisedCalciumRange & $Nul & sIonisedCalcium & $Nul & sIonisedCalciumUnit _
             & $Nul & Format$(Abs(lMgPhosphate)) & $Nul & sMgPhosphateRange & $Nul & sMgPhosphate & $Nul & sMgPhosphateUnit _
             & $Nul & Format$(Abs(lINORGPHOSPHATE)) & $Nul & sINORGPHOSPHATERange & $Nul & sINORGPHOSPHATE _
             & $Nul & sINORGPHOSPHATEUnit & $Nul & Format$(Abs(lTotalCholesterol)) & $Nul & sTotalCholesterolRange _
             & $Nul & sTotalCholesterol & $Nul & sTotalCholesterolUnit & $Nul & Format$(Abs(lHDLCholesterol)) _
             & $Nul & sHDLCholesterolRange & $Nul & sHDLCholesterol & $Nul & sHDLCholesterolUnit _
             & $Nul & Format$(Abs(lLDLCholesterol)) & $Nul & sLDLCholesterolRange & $Nul & sLDLCholesterol _
             & $Nul & sLDLCholesterolUnit & $Nul & Format$(Abs(lTRIGLYCERIDES)) & $Nul & sTRIGLYCERIDESRange _
             & $Nul & sTRIGLYCERIDES & $Nul & sTRIGLYCERIDESUnit & $Nul & Format$(Abs(lFastingGlucose)) _
             & $Nul & sFastingGlucoseRange & $Nul & sFastingGlucose & $Nul & sFastingGlucoseUnit _
             & $Nul & Format$(Abs(lRandomGlucose)) & $Nul & sRandomGlucoseRange & $Nul & sRandomGlucose _
             & $Nul & sRandomGlucoseUnit & $Nul & Format$(Abs(lGLYCATEDHEAMOGLOBIN)) & $Nul & sGLYCATEDHEAMOGLOBINRange _
             & $Nul & sGLYCATEDHEAMOGLOBIN & $Nul & sGLYCATEDHEAMOGLOBINUnit & $Nul & Format$(Abs(lFRUSTOSAMINE)) _
             & $Nul & sFRUSTOSAMINERange & $Nul & sFRUSTOSAMINE & $Nul & sFRUSTOSAMINEUnit & $Nul & Format$(Abs(lGlucose)) _
             & $Nul & sGlucoseRange & $Nul & sGlucose & $Nul & sGlucoseUnit & $Nul & Format$(Abs(lProtein)) _
             & $Nul & sProteinRange & $Nul & sProtein & $Nul & sProteinUnit & $Nul & Format$(Abs(lCHLORIDE2)) _
             & $Nul & sCHLORIDE2Range & $Nul & sCHLORIDE2 & $Nul & sCHLORIDE2Unit & $Nul & Format$(Abs(lOccultBlood)) _
             & $Nul & sOccultBloodRange & $Nul & sOccultBlood & $Nul & sOccultBloodUnit & $Nul & Format$(Abs(lOthers)) _
             & $Nul & sOthersRange & $Nul & sOthers & $Nul & sOthersUnit & $Nul & Format$(Abs(lAmylase)) _
             & $Nul & sAmylaseRange & $Nul & sAmylase & $Nul & sAmylaseUnit & $Nul & Format$(Abs(lTOTALACIDPHOSPHATASE)) _
             & $Nul & sTOTALACIDPHOSPHATASERange & $Nul & sTOTALACIDPHOSPHATASE & $Nul & sTOTALACIDPHOSPHATASEUnit _
             & $Nul & Format$(Abs(lPROSTATICACIDPHOSPHATASE)) & $Nul & sPROSTATICACIDPHOSPHATASERange _
             & $Nul & sPROSTATICACIDPHOSPHATASE & $Nul & sPROSTATICACIDPHOSPHATASEUnit & $Nul & Str$(Abs(lALKALINEPHOSPHATASE)) _
             & $Nul & sALKALINEPHOSPHATASERange & $Nul & sALKALINEPHOSPHATASE & $Nul & sALKALINEPHOSPHATASEUnit _
             & $Nul & Format$(Abs(lCPK)) & $Nul & sCPKRange & $Nul & sCPK & $Nul & sCPKUnit & $Nul & Format$(Abs(lGammaGT)) _
             & $Nul & sGammaGTRange & $Nul & sGammaGT & $Nul & sGammaGTUnit & $Nul & Format$(Abs(lLDH)) & $Nul & sLDHRange _
             & $Nul & sLDH & $Nul & sLDHUnit & $Nul & Format$(Abs(lASAT)) & $Nul & sASATRange & $Nul & sASAT & $Nul & sASATUnit _
             & $Nul & Format$(Abs(lALAT)) & $Nul & sALATRange & $Nul & sALAT & $Nul & sALATUnit & $Nul & Format$(Abs(lPSA)) _
             & $Nul & sPSARange & $Nul & sPSA & $Nul & sPSAUnit & $Nul & Format$(Abs(lTotalBilirubin)) & $Nul & sTotalBilirubinRange _
             & $Nul & sTotalBilirubin & $Nul & sTotalBilirubinUnit & $Nul & Format$(Abs(lConjBilirubin)) & $Nul & sConjBilirubinRange _
             & $Nul & sConjBilirubin & $Nul & sConjBilirubinUnit & $Nul & Format$(Abs(lTotalProtein)) & $Nul & sTotalProteinRange _
             & $Nul & sTotalProtein & $Nul & sTotalProteinUnit & $Nul & Format$(Abs(lAlbumin)) & $Nul & sAlbuminRange & $Nul & sAlbumin _
             & $Nul & sAlbuminUnit & $Nul & Format$(Abs(lGlobulin)) & $Nul & sGlobulinRange & $Nul & sGlobulin & $Nul & sGlobulinUnit _
             & $Nul & Format$(Abs(l0Min)) & $Nul & s0Min & $Nul & s0MinUnit & $Nul & Format$(Abs(l30Min)) & $Nul & s30Min & $Nul & s30MinUnit _
             & $Nul & Format$(Abs(l60Min)) & $Nul & s60Min & $Nul & s60MinUnit & $Nul & Format$(Abs(l90Min)) & $Nul & s90Min _
             & $Nul & s90MinUnit & $Nul & Format$(Abs(l120Min)) & $Nul & s120Min & $Nul & s120MinUnit & $Nul & Str$(Abs(l150Min)) _
             & $Nul & s150Min & $Nul & s150MinUnit & $Nul & Format$(Abs(l180Min)) & $Nul & s180Min & $Nul & s180MinUnit _
             & $Nul & Format$(Abs(lUrineProtein)) & $Nul & sUrineProteinUnit & $Nul & Format$(Abs(lUrineGlucose)) _
             & $Nul & sUrineGlucoseUnit & $Nul & Format$(Abs(lUrineBilirubin)) & $Nul & sUrineBilirubinUnit _
             & $Nul & Format$(Abs(lUrobilinogen)) & $Nul & sUrobilinogenUnit & $Nul & Format$(Abs(lKetones)) & $Nul & sKetonesUnit _
             & $Nul & Format$(Abs(lpH)) & $Nul & spHUnit & $Nul & Format$(Abs(lSG)) & $Nul & sSGUnit & $Nul & Format$(Abs(lBlood)) _
             & $Nul & sBloodUnit & $Nul & Format$(Abs(lPregnancyTest)) & $Nul & sPregnancyTestUnit & $Nul & Format$(Abs(l24HRURINEPROTEIN)) _
             & $Nul & s24HRURINEPROTEINUnit & $Nul & Format$(Abs(l24HRURINESODIUM)) & $Nul & s24HRURINESODIUMUnit _
             & $Nul & Format$(Abs(l24HRURINEPOTASIUM)) & $Nul & s24HRURINEPOTASIUMUnit & $Nul & Format$(Abs(lCretinineClearance)) _
             & $Nul & sCretinineClearanceUnit & $Nul & Format$(Abs(lUrineOthers)) & $Nul & sUrineOthersUnit _
             & $Nul & sMedLabName & $Nul & sMedLabDate), "E")

slExe "End"



Best regards,
67
You've got Questions? We've got Answers! / Copy a record
December 20, 2010, 01:22:12 pm
Hello, How can one copy a record from one table to another table? Best regards.
68
Hello Jim,

I
69
Hello,

I have a table structure like this:



slExe "Create Table If Not Exists tblSalaryStructure (GLS Unique, Amount)"



I want to be able to increment or decrement the Amount field based on a percentage of the Amount Value in a column. Is it possible to do that with SQL?

Any help be appreciated.

Best regards,

70
Hello,

How can one delete empty spaces in a field using the SELECT Statement?

Best regards,
71
Hello,

I have a table that I would like to query in Descending order this way:


slSel "SELECT * FROM tblMainInventory WHERE Date BETWEEN '" + sFrom + "' AND '" + sTo + "' ORDER BY  " & sSortBy & " DESC "


But I don
72
Hello,

I have a weird situation here with different Date Formats/Queries. When I use this query:


slSEL "SELECT * FROM tblCreditSales WHERE InvoiceNo = '" + sInvoiceNo + "' AND Date = '" + sDate + "'"

and my date format is "yyyyMMdd"

My query returns nothing. But when my date format is "yyyy-MM-dd", my query returns ok.

Then again, when my query is:


slSEL "SELECT * FROM tblCashSales WHERE Date BETWEEN " & sFrom & " AND " & sTo & ""

date format is "yyyyMMdd"
73
Hello,

This program was running fine when the PIN field was integer which was the client
74
Hello,

How do you test if an Update is successful or not?

Best regards,
75
Hi, wondering if SQLite limitations wholly applies to SQLitening except for the File Server vs Client/Server attributes. I'm thinking of converting a fairly large application that could run on 20 workstations. Kind regards,
76
Hi, I' ve read the limitations SQLite. Wondering if its limitations wholly applies to SQLitening except for the File Server vs Client/Server attributes. I'm thinking of converting a fairly large application that could run on 20 workstations. Kind regards,
77
Hello, I get this error - can not get routine "sqlite3_shutdown" each time I exit my program. I am using local mode. Kind regards.
78
Hello All,

How do I accomplish the query below using slExeBind? The slExeBind examples used in sample programs isn't really clear to me.


slSel "SELECT * FROM tblPayments WHERE [Date] BETWEEN [" & sFrom & "] AND [" & sTo & "] AND [Depositor] = '" + sDepositor + "' "


Kind regards,
79
You've got Questions? We've got Answers! / Move Next
February 10, 2010, 07:40:33 am
Hello,

How do you move from the first record to the next record?

Kind regards,
80
Hello,

I'm curious here as to what mode (Local or Remote) to use if I need to have my program run on a Pier to Pier Network. No Server. All computers connected as clients, but the program residing in one of the clients and then creating shortcut of the exe on all other clients. Program working as a file server.

Best regards,