Search options (Page 4 of 17)

try

procedure frmLogin_Button1_OnClick ( Sender: string; var Cancel: boolean ); // check credentials and, if okay, show Form1
///////////////  Login, password, user rights  /////////////////////
var
    chk: Integer;
begin
    chk := SQLExecute('SELECT COALESCE(id, -1) FROM users WHERE lldelo LIKE '''+frmLogin.Edit1.Text+''' AND pass LIKE '''+StrToMD5 ( frmLogin.Edit2.Text )+'''');   
    // opt 2
    // chk := SQLExecute('SELECT COALESCE(id, -1) FROM users WHERE lldelo LIKE '''+frmLogin.Edit1.Text+''' AND pass LIKE '''+UPPERCASE(StrToMD5 ( frmLogin.Edit2.Text ))+'''');         

   if chk > 0 then
       Form1.Show;
end;

again, it is better for you to attach a sample working program with the problem, It would be much easier that way

frmOrderProduct.Button6.dbDontResetID := False;

This code will always make make it add new record if you are not closing the form after saving.

it will be much appreciated if you can attach if not your project, just a simple one so that people can check it out easily. It is much easier to debug with it

I'm not so sure to what will be the implementation of the idea but here's a sample that will get you started. Hope it'll help.

Hello,

Two option enter into my mind to address it.

Option 1. Do have a field (a hidden maybe) that will handle the calculated field, then put the calculation in the OnClick Event of the Save button
Option 2. If you are familiar with trigger, I am using it in some of my projects with complex saving or interaction with other table, in this sample, I just use 1 table.

Take note that you must be familiar if not expert with trigger, personally I am enjoying using triggers, procedures and functions (proc and func is only available for mySQL thou). Triggers are also difficult to maintain so for beginner, I would go with Option 1.

That dictionary also fixed my problem here http://myvisualdatabase.com/forum/viewtopic.php?id=7339 by setting department as dictionary

That's great derek. There you have option now frank.
For your reference or future works, here's how you do it. You can choose what button/s you want to hide by simple removing it from the equation. I used it on some of my project with trial version. I excluded their print and exprot pdf so that they can preview the report but can't do anything with it except having print screen of it.

Hi domebil,
I raised this same question for quite sometimes now.

As I work with Delphi(where MVD was made, just not sure to what version of it) for couple of months now, it has been clear to me that this will be quiet difficult (making MVD open-source) to attain. I believe that there are some paid components used to it. Fast-Report, the code editor, perhaps the map component are all paid components so for it to someone to edit/update MVD, they have to pay for all of it.

For me, as of now, I am hoping that our concerns will reach out Dmtry and if not him, maybe some of his colleague, teammates will continue on updating the project(MVD). I think that's our best hope for now.

I am continue learning Delphi for bigger projects to come. For now, our team was able to extend our application's functionality by creating sub-application on Delphi that will cater feature (like the google map component) that can't be done or is outdated in MVD

use update query if you want to update existing records and set the field to 1 for TRUE.

SQLExecute('UPDATE `work` SET kryfo=1 WHERE 1');

You can set the tele as orphan by setting their id_Customer to null, then proceed to deleting the Customer.
I just don't know to what are you going to do with that orphaned tele data. But here's one way of doing it.

Something I found on that function ToWords is the fourty which has to be forty. Here's my converted function from php. Maybe you could do some tweak on the initialization and other function to meet your requirement such as changing to other language.

Goodluck.

Maybe something like this might help you.