Search options (Page 5 of 16)

Hello unforgettable, StateOne:

I'm confused. are you just trying to access the last record of your table? If so then you can just do

Select  * from xyz ORDER BY id DESC LIMIT 1

In this way you don't have to include subquery. You don't want it to slow down your query especially for a well-populated table
Then for e.g. last id is 300, being no gap in the IDs, to access 299,

Select  * from xyz ORDER BY id DESC LIMIT 1, 1

for 298

Select  * from xyz ORDER BY id DESC LIMIT 2, 1

for 297

Select  * from xyz ORDER BY id DESC LIMIT 3, 1

and so on.

For the conditional, try elaborating further the result you want to obtain for us to look for a solution.

It is to compute for the receivable, deducting discount from sTotal.

You haven't attached your project. I used the last attachment from my replies.

Well, trigger will help but in my opinion, if you aren't that familiar with trigger, then you study it first. There are other method to avoid the calculated fields(Most probably, this are the ones responsible in slowing your application). All you can do is just edit that calculated field (In this example the Sales_Ticket.sTotal) to a regular field(Currency in this case). Then handle the calculation in your code.

I'm thinking you already deployed your application to your client or you are using it.

I handle problem like this by saving a version number to the database (something like `settings`.`dbVersion`). Then, I created script to handle the alter queries. You need to carefully document each changes in your database

From the script.pas, I am indicating a CONST variable e.g.

CONST DBVER = 2; // this is the current version on the development database. I always change this manually on the dev database to avoid error when developing.

Then, executing the db revision checking on the begin end. area

procedure DBREVISION();
var currVer: Integer;
begin
    currVer := := SQLExecute('SELECT COALESCE(dbVersion, 0) AS currVer FROM settings WHERE 1 LIMIT 1');
    if currVer < DBVER then
    begin
        if DBVER < 1 then
        begin
            // alteration of the version 1
        end;
        if DBVER < 2 then
        begin
            // alteration of the version 2
        end;
        SQLExecute('UPDATE `settings` SET dbVersion='+IntToStr(DBVER));
    end;
end;

begin
    DBREVISION;
end.

I hope this can give you an idea on how handle your problem

Try changing the table for the query setting of the grid from newentry form and set it to customers

I think the only way for you to make it work is to make it dual boot or install windows on a virtualbox

I already sent it. You can also refer to this topic

http://myvisualdatabase.com/forum/viewtopic.php?id=7915

Sure, i'll send it to you

You can put it under the installation folder of your MVD. In my case it is under "C:\Program Files (x86)\My Visual DataBase"

just make sure to have a backup of the current sqlite, you might run into an error when accessing 2 level of parent of a child in a report using the new version of sqlite. I hope you dont have this kind of record in your project/application. This error was not been fixed.

Here's my post with regards to the problem
http://myvisualdatabase.com/forum/viewtopic.php?id=7339

Here's a workaround I've made in my project that act like numberbox. It doesn't have button thou.

Here. I have the 5.5 version.
https://www.dropbox.com/s/nlita5g2w75w7 … 5.exe?dl=1

Again, there are many ways to do it.

For the purchase price and selling price, in my experience, saving this details will only give you estimated markup(when the price differ on your next stock or purchase transaction of the goods/item and the store has remaining stock of it). You don't want your application to check the quantity of each stock transaction you made and tag each sales/pullout of the item to where stock transaction you get it from.

If you are trying to compute exact income of the store, it is better to just have a cashflow module that will handle it.
Saving all expenses and sales/collections.

Then,
Income = Total(Sales/Collections) - Total(Expenses, this includes the purchase of the goods/stock basically).

Just charge your client on the additional module(cashflow). 3:)