• Welcome, Guest. Please login.
 
August 22, 2019, 09:53:31 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

41
Hello,

Is it best practice to save Images in a separate table? Because when I tried saving an image along with other items the image get saved but I null in other fields.


slExe "Begin Immediate"
            Errorcode& = slExe (slBuildInsertOrUpdate("tblBioData", "'" & sPHINo & "'" & $Nul & sTitle & $Nul & sSurname & $Nul & sOthernames _
            & $Nul & SQLiteDate(sDateCreated) & $Nul & sAddress & $Nul & sOccupation & $Nul & sSex & $Nul & sChronicConditions & $Nul & sAge _
            & $Nul & sAgeClass & $Nul & sMaritalStatus & $Nul & sSpouseName & $Nul & SQLiteDate(sBirthDate) & $Nul & sReligion _
            & $Nul & sPlan & $Nul & sClass  & $Nul & sFamilySize & $Nul & sGenotype & $Nul & sBloodGroup & $Nul & sKinName & $Nul & sPixName _
            & $Nul & sExpiryDate),"E")
           
           slGetFile sPixName, lsA
           slExeBind slBuildInsertOrUpdate("tblBioData","?", "Images"), slBuildBindDat(lsA)
   
        slExe "End"
42
Hello,

I have a tricky one here. Joining 3 tables. None Is A Primary Table. These are the tables with their indexes:

tblClaimsAnalysis


slExe Build$("Create Table If Not Exists tblClaimsAnalysis(Register TEXT, HospitalNo TEXT COLLATE NOCASE, Surname TEXT, MaidenSurname TEXT, Othernames TEXT, Category TEXT, Date TEXT,", _ 
      "IDNo Text, NotificationDate Text, AuthorizationOfficer Text, AuthorizationCode Text, AccommodationDays TEXT, FeedingDays TEXT, AdmissionDate TEXT, DischargeDate TEXT, DoctorInCharge TEXT)")
       
slExe "Create Index If Not Exists ClaimsAnalysisndx1 ON tblClaimsAnalysis(HospitalNo, Surname, Othernames)"
     


tblSales


slExe "Create Table If Not Exists tblSales (HospitalNo TEXT, Surname TEXT, Othernames TEXT, Address TEXT, InvoiceNo INTEGER, Date TEXT," & _
       "ProductNo TEXT, Description TEXT, Category TEXT, Brand TEXT, Quantity INTEGER, SellingPrice REAL, Discount REAL, Remarks TEXT, Username TEXT)"
       
slExe "Create Index If Not Exists Salesndx ON tblSales (InvoiceNo, HospitalNo)"
       


tblBill


slExe "Create Table If Not Exists tblBill(Date TEXT, BillNo TEXT, HospitalNo TEXT COLLATE NOCASE, Surname TEXT, Othernames TEXT, Category TEXT," & _
       "CodeNo TEXT COLLATE NOCASE, Service TEXT, Amount REAL, Discount REAL, Status TEXT)"
               
       slExe "Create Index If Not Exists Billndx1 ON tblBill(HospitalNo, CodeNo, Category)"
       


I need to be able to join these tables and create a report list that looks like these:


[b]Name   Date  IDNo  Amount[/b]


Name, Date and IDNo comes from table tblClaims Analysis while Amount comes from both tblSales and tblBill.

Any help would be appreciated.



43
Hello,

Is there a tool one can use to read SQLServer Records Into SQLite/SQLitening Table?  Something like Cheetah2SQLite tool we had sometime ago.
44
Hello,

With the help of Tramp I got this far, but not working as shouldl. It only save the last record displayed on the Listview and duplicates it based on the number of records on the Listview. For instance if there are 3 records on the listview, it will save the last record and add two more records of the same last records. if there are 2 records on the listview, it will save the last record and add one more record of the same last records and so on.

Not sure why this happening. A possible bug?



ListView Get Count nCbHndl, %ID_FRMUPDATESALES_LISTVIEW2 To Rows
    Cols = 12   
    ReDim sArray(1 To Rows*Cols)
    For Row = 1 To Rows
      cols = 0
      Incr Cols : LISTVIEW Get Text nCbHndl, %ID_FRMUPDATESALES_LISTVIEW2, rows, Cols To m_sCustomer
      sArray((Row - 1) * 12 + Cols) = slBuildBindDat( m_sCustomer, "T")
      Incr Cols : LISTVIEW Get Text nCbHndl, %ID_FRMUPDATESALES_LISTVIEW2, rows, Cols To m_sAddress
      sArray((Row - 1) * 12 + Cols) = slBuildBindDat( m_sAddress, "T")
      Incr Cols : LISTVIEW Get Text nCbHndl, %ID_FRMUPDATESALES_LISTVIEW2, rows, Cols To m_sInvoiceNo
      sArray((Row - 1) * 12 + Cols) = slBuildBindDat( m_sInvoiceNo, "T")
      Incr Cols : LISTVIEW Get Text nCbHndl, %ID_FRMUPDATESALES_LISTVIEW2, rows, Cols To m_sDate
      sArray((Row - 1) * 12 + Cols) = slBuildBindDat( m_sDate, "T")
      Incr Cols : LISTVIEW Get Text nCbHndl, %ID_FRMUPDATESALES_LISTVIEW2, rows, Cols To m_sProductNo
      sArray((Row - 1) * 12 + Cols) = slBuildBindDat( m_sProductNo, "T")
      Incr Cols : LISTVIEW Get Text nCbHndl, %ID_FRMUPDATESALES_LISTVIEW2, rows, Cols To m_sDescription
      sArray((Row - 1) * 12 + Cols) = slBuildBindDat( m_sDescription, "T")
      Incr Cols : LISTVIEW Get Text nCbHndl, %ID_FRMUPDATESALES_LISTVIEW2, rows, Cols To m_sCategory
      sArray((Row - 1) * 12 + Cols) = slBuildBindDat( m_sCategory, "T")
      Incr Cols : LISTVIEW Get Text nCbHndl, %ID_FRMUPDATESALES_LISTVIEW2, rows, Cols To m_sQuantity
      sArray((Row - 1) * 12 + Cols) = slBuildBindDat( m_sQuantity, "I")
      Incr Cols : LISTVIEW Get Text nCbHndl, %ID_FRMUPDATESALES_LISTVIEW2, rows, Cols To m_sSellingPrice
      sArray((Row - 1) * 12 + Cols) = slBuildBindDat( m_sSellingPrice, "D")
      Incr Cols : LISTVIEW Get Text nCbHndl, %ID_FRMUPDATESALES_LISTVIEW2, rows, Cols To m_sDiscount
      sArray((Row - 1) * 12 + Cols) = slBuildBindDat( m_sDiscount, "D")
      Incr Cols : LISTVIEW Get Text nCbHndl, %ID_FRMUPDATESALES_LISTVIEW2, rows, Cols To m_sRemarks
      sArray((Row - 1) * 12 + Cols) = slBuildBindDat( m_sRemarks, "T")
      Incr Cols : LISTVIEW Get Text nCbHndl, %ID_FRMUPDATESALES_LISTVIEW2, rows, Cols To gUsername
      sArray((Row - 1) * 12 + Cols) = slBuildBindDat( gUsername, "T")
       
   Next
   
   slExeBind "Insert into tblSales values(?" + Repeat$( 11, ",?" ) + ")", Join$( sArray( ), "" ), "V12"   

45
Hello,

Is it possible to read multiple rows of a Listview and then save it into a table using SQLitening all at once? In other words saving multiple records all at once.
46
Hello,

Is it possible to export SQLitening Table to MS Excel?

47
Hello,

Is anyone using SQLitening and Listview together here?

Regards,
48
Hello,

With SQLitening is it possible to limit the number of Client Computers connected to the Server Computer (SQLiteningServer)?
49
Hello, been wondering what would make a LAN only run on 10mbps. I recently experienced this on two clients sites. It won't just connect when I configure the LAN to run on 100mbps. Only connects on 10mbps. What could be responsible for this? Won't this affect the performance of ones application? 

Best regards,
50
Hello

I am at a new client's site and I am trying to assign IP address to the clients and server computers. Noticed that some of the client computers I did assign IP address to manually would not connect to the server, but if I let the computer assign IP address to them automatically they would connect to the server without problems. I manually assigned IP address to the server computer though.

Few Questions:

1) Why is that so?
2) Is it ok to allow the computer assign IP address to the client computers automatically when using SQLitening?
3) Is it a must to create an exception for the port No (51234) on the client computers or is it only done on the server computer?

Best regards,
51
I would suggest we have all the files relating to the latest version (this time v1.54) in one folder and download link.
52
You've got Questions? We've got Answers! / Trigger Error
February 02, 2012, 01:28:21 pm
Not sure what is wrong with this Trigger Statement. Failed on the first line. Gives me syntax error 1.


slExe "Create TRIGGER SalesTrig after Insert On tblSales"
        slExe "Begin"
          slExe "update tblMainInventory Set QuantityCur=(Select QuantityCurrent From tblMainInventory where New.ProductNo=tblMainInventory.ProductNo)-New.Quantity;"
        slExe "End"
53
Hello,

I have this scenario. Its an inventory Software I am updating. Finding better ways to do things. I have a main table (tblMainInventory), Sales table (tblSales) and a Receives table (tblReceives).  The tblMainInventory is the base table while tblSales and tblReceives interacts with tblMainInventory to always arrive at the quantity in stock at any given time.

Lets say I have:

tblMainInventory  (ProductNo1) =  40
tblSales (ProductNo1) = 30
tblReceives (ProductNo1) = 20
Balance (ProductNo1) = 30

Now, I want to be able to use the SQL statement to do the above calculation for all the products available (Not just ProductNo1 alone) in one SQL Statement. Is it possible?

Best regards,
54
Hello,

Program connects and works fine but Error -18 still pops up intermittently.

The Clients and Server runs on Windows XP SP2.

Best regards,


55
Hello, a client called to tell me that they recently started getting error -16 when they try to run my application. From our discussions the network seems to be ok. So I gave them the instructions refresh the server through the TOOLS menu of the SQLiteningServerAdmin. They got a message saying it can't connect. What could be responsible?
56
Hello,

I am having problems restarting SQLitening server. Whenever there is a sudden Power outage the SQLitening Server would stop running and  when I try to restart it, I get this error message:

Quote
SQLitening server failed to start. There may have been a proceding error message. Check Log file. If nothing in Log file then error occurred before the server could start (missing required DLL?) or lack required privilages. Try starting from control panel.


Log file says
57
Hello,

I usual use the RowID as my Serial Number when displaying my records on a Listview. I noticed that whenever a record is deleted a gap is created in the serial numbering. E.g. Lets say I have: 1, 2, 3, 4, 5 and I delete record No 3.
The numbering display becomes 1, 2, 4, 5. Thus leaving a gap. Is there a function one can use to rebuild the rowid numbering to become 1,2,3,4?

Best regards,
58
Hello,

Is it possible to run to two different applications on one 'Computer Server'. I have my Hospital Management Software already running on the 'Computer Server' now I want to install a different application (Pharmacy Software) on that same server.

Is this ok?

Thanks.
59
Hello,

I'm in the verge of implementing C/S for a client for the first time. Rolf has been gracious enough to put me through what I need to do. I'm trying the remote access with just one system, but I'm having error -18 - 'Error sending or receiving message'.

It connects without error, but when I try to use the software (open a form) I get error -18. I also tried the remote access in my other application, same error.

Any idea this is coming from?

Best regards,

60
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?