thank yo so much all of you. the example "reteinformatic" is the close to what i want

thank you so much

i have a User Table and a Computer Table each user can have more then one computer .


i create a Form for the users list and create a button call Computer Info. what i want is when i click the Computer Info button the Computer Form Shows and display only the computer related to the selected user


i know i ask for too much but can anyone help me


Thank yo so much

3

(5 replies, posted in Script)

derek wrote:

Hi,
Thanks for attaching the example - it makes it much easier to understand your problem.
Please see attached which gives you 2 options.
Option 1 is where you highlight a row and click the 'leave date' button.
Option 2 is where you click in the actual 'leave date' cell of the tablegrid (to remind users that this column is 'interactive', I put an '*' against the column header (Leave Date*)
In both cases, I have added the option to un-set the 'leave date' (but only to make testing easier).
Regards,
Derek.

dd1 fixed is the one i was looking for

thank you so much

4

(5 replies, posted in Script)

derek wrote:

Hi,
If you zip your project (delete the .exe file and then zip your application folder), you will (almost) always get a quicker and more focused response to your question.
Derek.

thank you so much

i hope this simple example explaine my situation

5

(5 replies, posted in Script)

Hello everyone

i create a application managing my invontory and i need help in one thing

i creat a button use a function to insert a date in a selected row on a tablegrid 

but with no succes

can someone help me

6

(3 replies, posted in General)

sparrow wrote:

Hi, z.barkouk

1. At the forum, participants greet each other.
2. There is a search on the forum and a search through GOOGLE, which will give you a link to your request "check duplicate":

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

thank you so much i search on the form about this but it didn't give me this resoult

thank you so much

7

(3 replies, posted in General)

i create a user list

and when i insert a new user i want to check if this user already exist

is there any options to enable or do i need to do in with scripting

8

(15 replies, posted in SQL queries)

tcoton wrote:

What would you like to see in these videos?

Im a guy learn by going it

so i think create a database but with deep explaining of each option and mostly how to use scrpting

9

(15 replies, posted in SQL queries)

derek wrote:

i want to use a query for recursive Search but with search action MVD provide its a absolute search if i don't type the full name the search action wont give me any resoult

and the query you propose is not working it show no resoult what so ever

No, it is not an 'absolute' search (and the query does work).
Use the  'search' function with a filter of '%s%'.   Also optionally, use the 'increm.search' option to trigger your search automatically (see screenshot in the attached example).
Derek.

waw like that, thank you so much

Can i ask you something why don't you create videos on youtube better then those 2 videos from 3 or 4 years ago

10

(15 replies, posted in SQL queries)

sparrow wrote:

Hi all,


if you use Button SQL Query

use

select users.username from users where users.username like '%{useredit}%'

waw thank you so much is work perfectly thank you again

11

(15 replies, posted in SQL queries)

i want to use a query for recursive Search but with search action MVD provide its a absolute search if i don't type the full name the search action wont give me any resoult

and the query you propose is not working it show no resoult what so ever

12

(15 replies, posted in SQL queries)

first of all im in love with MVD

i tried so hard to learn how to create simple databases but with MVD is way easy

i tried to create a recursive search button using SQL QUERY

i have a entry where you put part of the name you search for and want to show a list of all lines have text entry in them

i tried and i know is not working thats why i ask for you help

select users.username from users where users.username LIKE '%+Form1.useredit.text%'