did you try the try except?
try
db_settings:=...
Conn.Open...
{query to get}
res.Open...
except
// your message here
end;
My Visual Database → Posts by brian.zaballa
did you try the try except?
try
db_settings:=...
Conn.Open...
{query to get}
res.Open...
except
// your message here
end;
Check all the anchor of your Grid from the Object inspector.
Form1.Tablegrid1.dbSQL := 'SELECT `date`,`items`,`value` FROM `sales`';
Form1.TableGrid1.dbSQLExecute;
There's no option to that for now. I hope MVD DevTeam can add this feature too. I'm looking forward to it too.
No, you must do some code in it.
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;
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.
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.
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.
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.
This might help.
Check for Show Record Buttons. You might duplicated your Show Record Button pointing to your Grid.
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.
You can try the New Record Action on the Clear Button.
We handle this thing using ALPHABLEND. I attached a sample program. Hope it helps.
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;
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.
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.
Wow! That zIndex solves the problem.
You are a life saver Dmitry.
Thanks much Drivesoft.
Please attach your project. I will check.
Thanks for the fast reply.
Here, i made some sample of the code.
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
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.
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.
Radio button too will be great.
My Visual Database → Posts by brian.zaballa
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi