Skip to forum content
My Visual Database
A Simple Solution for Creating Databases
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options (Page 3 of 4)
Hi to all.
I have a tablegrid displaying fields from a database.
For example name,surname,year
I want to color the entire grid row when the value of the "year" field is equal to a particular number lets say 1970.
So in this case all persons in the database with year=1970 should have their corresponding grid rows coloured to a specific color such as green.
When looking at the table one can easily see what people are of the year 1970 since their rows will be green.
What script could I use?
Thank you
George
The problem was the sql update statement.
I am trying to change the value of a field in a table based on a certain criterion.
I scroll through all the records checking that a specific field has a specific value. If it has then I want to update the value of another field of the same record. Example:
Record has 3 fields. All records belong to the same table.
f1,f2,f3
I read each record and check if f1 is equal to 1. If it is I want to update the field f3 of this record with a new value , lets say f3:='yes'
I want to do this for all the records in the table.
How can I update the current record that I have selected with the updata statement. What do I put in the 'where' clause?
Thank you
Sorry my mistake. Everything is ok.
I have run the above code having made some changes to correspond to my tables and fields.
The while loop does not exit even after having reached the end of the file. It continuesly loops.
Any suggestions?
Thanks
Ok.
Finally made it work. I hade a problem getting the name right for the webcamera. Once I got the name right in the script everything is ok.
Now I need to make the app a bit better. How can we have a preview window and a button to get the shot.
I need to see what the camera is looking at to take the shot. At the moment the button takes the picture but you do not know where the camera is looking at.
Thank you
Goodmorning to all.
Can someone please help me on this issue? I would greatly appreciate it.
Thank you
I tried it after some years and it works.
Thank you
Thank you for the script code. I will try it and post back.
Regards
George
Hi
I have a form to input data for car parts.
I wish to also store photos of the part. These photos will be taken with an attached webcam.
I wish to press a button and initiate the camera and then take a shot of the part. This shot will be saved in the record for that particular part that it belongs to.
I tried Dimitris vmd application but I cannot manage to take a picture.
I understand that I have to edit the script file and put the name of my webcam. But the name of my webcam is Microsoft® Lifecam HD-3000. When I insert this as the name of my web cam nothing happens. I press the button to get a picture and a DOS window appears for a second then it is gone. I am running windows 10 64bit.
Do you have any suggestions?
Thank you
Hi
I am building an application for storing data about car parts.
So for every part I want to store some pictures of it.
I have a form that I input all the data for each part. Is there a way to save multiple images of the part in its record? I could create for example 5 image fields to store these images but I have to import these images to each field by pressing the corresponding button 5 times, one for each image. Is there a way to have one field that will store multiple images? I wish to select all these images together at once an insert them in the record. The DBImage supports only one file.
Thank you
George
I have the same problem.
Please see attached document.
Thank you.
I managed to accomplish what I wanted following this : http://myvisualdatabase.com/forum/viewtopic.php?id=2722
Now I want to find a way to loop through all the records of a table and create another table with additional data.
For example:
I have a table with two fields Name, Surname.
I want to loop through all the records and create another table with fields Name2,Surname2
Name2,Surname2 will contain data from initial Name and Surname fileds but they will be modified by a script to contain additional information.
Can you please help me on how to do the following tasks with scripts:
1. loop through all records
2. save Name2 and Surname2 data to a different table
Thank you
George
Hi
I have a user form where I can choose what part of a car will be dismantled (checkboxes).
Lets say that I choose 3 parts. The starter, the alternator and the fuel pump.
I want to create 3 records at once, one for each product. I wll later edit each record to input more metadata.
What script should I use to accomplish this?
Finally what language is used in MVD and what book can I use to learn this language?
Thank you
George
Please can anyone help?
thanks
George
Hi
On a form I have a calendar picker with "MultiSelect" = True.
I wish to be able to select many dates at the same time.
How can I store the selected dates to a database field?
If I save them to a date or text field only the fist data is saved. The other selected dates are lost.
I wish to make an application to book room reservations.
Any help will be of much help.
Thank you
George
Can MyVisualDatabase be used to create web applications? Can an application made with this software be run through a browser so that many users can use it? Can a database be stored in the cloud and many users running local applications read and store data to it?
Thank you
George
Hi
I have not found a solution. I program on a laptop with hd display. When I run the app on other computers with other resolutions I have problems.\
Also under windows 10 many times the app does not appear correct on screen. Do you have any settings that I have to apply to the app (right click on app icon >>>properties) so that windows runs it correctly?
Can someone help me on the above issues?
Thanks
George
Hi
In the same form I also have some simple text fields. How can I clean the contents of these fields with a click of a button on the form?
Can someone please recommend a good book to learn to program in MyvisualDatabase?
Thanks
George
Hi to everyone,
I still have'nt found a solution to my problem.
On a form I have one drop down list with items in english (FORD,RENAULT.....).
The other fields on the form are filled in Greek.
When I get to the drop down list I have to change the keyboard layout pressing Alt+Shift so I can select a value from the list. This is tiresome. Is there a way when entering the drop down list field the language to change automatically to english?
I have tried the above solutions but they do not work.
Thanks
Greece
Dmitry,
Please check your mailbox. I have sent my project twice. I did not receive any negative reply from my email program.
Thank you again for your time.
George
Hi
I use a grid to display the records of my database. One of the fields is a combobox. Is there a way to change the value of the combobox inside the grid without opening the record. I would like to press on the combobox value in the grid and have the combobox values displayed as a list I can choose from. This way is much faster when editing records.
Thank you
Hi
Do we have an update on this issue?
Thank you
Please email me at geochrist@gmail.com so that I can send you more info. My app has confidential data and I do not want to post it on the forum.
Unfortunately it does not work.
To change the keyboard I must press Alt+Shift simultaneously. How can I automate this?
Thank you.
I will try it and post back.
Posts found: 51 to 75 of 81