376

(1 replies, posted in General)

did you try the try except?

try
    db_settings:=...
    Conn.Open...

    {query to get}
    res.Open...
except
    // your message here
end;

377

(1 replies, posted in General)

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

378

(1 replies, posted in General)

Check all the anchor of your Grid from the Object inspector.

379

(4 replies, posted in SQL queries)

Form1.Tablegrid1.dbSQL := 'SELECT `date`,`items`,`value` FROM `sales`';
Form1.TableGrid1.dbSQLExecute;

380

(2 replies, posted in General)

There's no option to that for now. I hope MVD DevTeam can add this feature too. I'm looking forward to it too.

381

(1 replies, posted in General)

No, you must do some code in it.

382

(5 replies, posted in Script)

Yes it is possible to load data via script but why would you want to load it via script when you can load data on the Settings of the tablegrid1? Another option is to load data using search button with corresponding filters.
Here's a sample snippet of populating grid via script.

Form1.Tablegrid1.dbSQL := 'SELECT `date`,`items`,`value` FROM `sales`';
Form1.TableGrid1.dbSQLExecute;

383

(1 replies, posted in Script)

I want to see your code. I'm using this method of including files. Maybe something's wrong with your script if all procedures and functions included in the external files are working but the one button procedure.

384

(2 replies, posted in General)

Just use the Transaction statement START TRANSACTION and COMMIT e.g

try
    SQLExecute('START TRANSACTION');
    ...
    ...
    ...
    SQLExecute('COMMIT');
except
    SQLExecute('ROLLBACK');
end;

It will depend on how your script works or how you want it to work. You may want to add START TRANSACTION statement on the OnClick Procedure of the button, then the COMMIT on the AfterClick Procedure. You can attach some project here, what you want to do with Transaction and someone will give you workarounds. Cheers.

385

(7 replies, posted in General)

Hello MVD Wizards.

Is it possible to disable UpdateDatabase('') function to run background, I mean when the system starts?

I want to run it manually after showing my Main Form for having bulk data makes login form to show very late.

I done it on mysql using the disable_connectdialog but how can I do such thing on sqlite?

Thank you in advance.

386

(0 replies, posted in General)

Good Day MVD Dev.

Can you add an option for the On Delete Set Null Constraint next to the Cascade Option on the relationship on your next update?

Doing this on script for now. I'm having problem setting it directly to the database for changing some fields on the table from MVD will reset the constraint I've made from my table.

Thank you in advance.

387

(1 replies, posted in General)

This might help.

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

Check for Show Record Buttons. You might duplicated your Show Record Button pointing to your Grid.

389

(4 replies, posted in General)

sibprogsistem wrote:

everything except files :
            PhoneBook.vdb
            Script/script.dcu

It's everything except:
            PhoneBook.vdb
            Script/script.pas

As per JB, .pas must be the one that is excluded for it is your source code. In addition,

only the compiled version is useful to him

also, any user with knowledge to programming can manipulate your application if you include your source code.

390

(4 replies, posted in General)

You can try the New Record Action on the Clear Button.

391

(2 replies, posted in General)

We handle this thing using ALPHABLEND. I attached a sample program. Hope it helps.

392

(2 replies, posted in General)

Good Day MVD Wizards.

Does anyone know how to add label to polygon via script?
I have this snippet here but Polygon.LabelText is not working.
I can't find a list of property that can be used for the TPolygonItem.

while not Results.EOF do begin
    if number <> Results.FieldByName('number').AsInteger then begin
        if PolygonItemRegion <> nil then // create/add
            frmMain.Map1.CreateMapPolygon(PolygonItemRegion.Polygon);

        PolygonItemRegion := frmMain.Map1.Polygons.Add;
        PolygonItemRegion.Polygon.LabelText := 'I WANT TO SHOW THIS LABEL';
        PolygonItemRegion.Polygon.BackgroundColor := bColor;
        PolygonItemRegion.Polygon.BackgroundOpacity := bOpacity;
        PolygonItemRegion.Polygon.BorderColor := clLime;
        PolygonItemRegion.Polygon.HoverBackgroundColor := clWhite;
        PolygonItemRegion.Polygon.HoverBorderColor := $000080FF;
        PolygonItemRegion.Polygon.BorderWidth := 1;
        PolygonItemRegion.Polygon.Tag := -1;
    end;
    number := Results.FieldByName('number').AsInteger;
    PolygonItemRegion.Polygon.Path.Add(Results.FieldByName('lat').AsFloat, Results.FieldByName('lon').AsFloat);
    Results.Next;
end;

393

(12 replies, posted in General)

brian.zaballa wrote:

Nice feature on the ability to create user and role. Can you add option/module for the users(non-admin) to update their own password? And is it possible to have user(non-admin again) to access or update other user(non-admin)?  Hierarchy being

Admin(super admin, currently the admin)
UserAdmin(user admin thar can access and update other non-super(admin) users)
User(regular user that can only update their password)

Thank you and nicely done MVD team.

My bad, I've read thoroughly the post and the functions I'm looking is on the development stage and will be added soon(as said). Can't wait for the update on this one. This saves time coding for the roles.

394

(12 replies, posted in General)

Nice feature on the ability to create user and role. Can you add option/module for the users(non-admin) to update their own password? And is it possible to have user(non-admin again) to access or update other user(non-admin)?  Heirarchy being

Admin(super admin, currently the admin)
UserAdmin(user admin thar can access and update other non-super(admin) users)
User(regular user that can only update their password)

Thank you and nicely done MVD team.

395

(4 replies, posted in General)

Wow! That zIndex solves the problem.
You are a life saver Dmitry.

Thanks much Drivesoft.

396

(4 replies, posted in General)

DriveSoft wrote:

Please attach your project. I will check.

Thanks for the fast reply.
Here, i made some sample of the code.

397

(4 replies, posted in General)

Good Day Wizards. I'm having problem on rendering Routes and Area.
Some of the routes seems fine (overlapping the area) but there are times other routes don't.
I am rendering maps(area, route and marker) via script. I already tried loading all routes after loading area but the result is the same.
Is there any way to correct this
Markers must overlap routes, and routes must overlap area.
Thanks in advance

398

(2 replies, posted in General)

DriveSoft wrote:

Hello.


Form not close because in the setting of Save button on f1 form you have unchecked checkbox "Close the current form after saving"


What exactly you want to do using dbDontResetID property?

I intentionally unchecked it. I don't want form to close right after saving. The problem is the adding of child for the new record for f1 right after saving the new record.

399

(2 replies, posted in General)

Good Day Wizards.

Can anyone help me in this problem?
I'm having hard time on Form (not close when saved)

Problem Occurred when:
1. Add New Item from Main
2. Enter Data Field1, FIeld2
3. Click Save
4. Click Add Child
5. Enter Data Field3
6. Click Save

Other process is OK Like, Edit, or clicking Add Child before clicking Save from Form 1

Thanks in Advance.

400

(188 replies, posted in General)

Radio button too will be great.