how to get the values from other table?
-
how to call the data from other table? let say i want to generate a doc number that is in this format . i don't know how to call the value field run_no from table runNO. the doc no formula is docNo = System.DateTime.Now.ToString("yyyyMMdd") + Kod.Text + "values from run_no (table runNO)" rite now my docNo only have <20080216>... helppppppppp...
-
how to call the data from other table? let say i want to generate a doc number that is in this format . i don't know how to call the value field run_no from table runNO. the doc no formula is docNo = System.DateTime.Now.ToString("yyyyMMdd") + Kod.Text + "values from run_no (table runNO)" rite now my docNo only have <20080216>... helppppppppp...
Perhaps if you could explain yourself a bit better ? Does table mean a SQL database ? You get data out of a table by querying it with SQL.
Christian Graus - Microsoft MVP - C++ "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
-
Perhaps if you could explain yourself a bit better ? Does table mean a SQL database ? You get data out of a table by querying it with SQL.
Christian Graus - Microsoft MVP - C++ "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
i'm doing a program using microsoft visual studio. each time i submit my data, it will generate a doc number that is in . My formula docNo = System.DateTime.Now + kod + . kod is the value from a text box. for running number, i have a function GetRunNo that will update a table in my sql database each time i submit a data. in the table there r 2 field that is run_no and date. Each time i click add button it will update the running number base on date, it will add the data in the database, and each data will have a doc number for our reference. how can i call the values in that table to put in the doc number?