Hi: What you need is to use your variables "pstr", because you are not concatenating their values. And I also give you two recommendations: - Use an standard...
Jean Honorio Carrillo
jhonorio@...
Apr 1, 2004 4:46 pm
5650
UPDATE [tblStores] SET fldCode = pstrZone, fldCName = pstrSName, fldZone = pstrStoreName, etc. etc. WHERE fldOName = ..... kenyetteinmiami...
Hi The statement what you are writing for Update is wrong, It should be strUpdateStore = ("UPDATE [tblStores] SET fldCode=pstrZone,fldCName=pstrSName ....."...
I think this is syntax error.. We can not update like this but it can wor for strUpdateStore = ("UPDATE [tblStores] SET fldCode = pstrZone fldCName =...
C.A.Arul
arul@...
Apr 1, 2004 4:48 pm
5653
The code is wrong.. The code should look like below: strUpdateStore = ("UPDATE [tblStores] SET " &_ "fldCode='" & pstrZone & "',fldCName='" & pstrSName &...
Hi All! I am using DBGrid control in VB, and then I have a question about it. I inserted a column on DBGrid without any value and I want to initialize it...
I have inherited an application in VB5. I need to update a form which contains a toolbar. I added a button to this toolbar and tried adding a caption for the...
I have never programmed using RDO (I have always used ADO) and need some assistance. I wrote the following piece of code to query a database and ascribe the...
Hi all, I am confused about object creation ( Connection , DataSet Objects.) When I create connection , dataset objects are they shared by all the clients...
Hi all, I have a large amount of data to be filled in separate dropdowns for City-Name, Category-Name and Company Name. the average no of records are 30-40...
Somebody please help me how can i open *.doc files in VB6 without having MSWord installed in the system. For example you can open .rtf files in richtextbox....
hello! well my dear suppose if ur applicaiton is running on two different computers both sharing the same database which is on a 3rd remote computer So...
I would recommend u doing this task wid the help of XML. Store data in XML rather than into database XML files are much quicker to access than the Database ...
"XML files are much quicker to access than the Database" ummm...right...quicker in what way?! Nick ... ply&messageNum=5662 Please do not reply to this message...
Accessing 30-40k records using MS Access is a lot to ask. Is there a way you can use SQL Server? A relational database with indexes should be quicker than MS...
I have to agree with this. The Database generates the XML files in the first place. Extra overhead on the DB there. My solution to this would be to turn on...
30-40K records is what Access was made for. I could understand an argument against using Access for 500K records with really complex queries or something. ...
Make program that uses tv cards remore control and via remote control program ll control computer i mean simple actiivi. Shutdown etc ... From: Arsal....
hello all... how to convert number format like 8E+7 to normal long decimal like 80.000.000 I ussually use function number_format() in PHP to solve that. is...
... Here is an example based on the Northwind database on your local system (created by MSDE installation). It assumes you have a Datagrid (Datagrid1) that...
... there a ... Uh, you did say .NET didn't you? Okay, let's try that again... .NET uses .ToString to format values. Here is the same example in .NET code......
... there a ... The Format statement should help... try Format(value,"#,###,###") (you may have to switch the ,'s to .'s I have not tried this when set to a...
Asalam O'Alaikum i have a problem to enter data like a voucher[sale,purchase,etc.] in webpage using asp.net or c#.net i can't find DataGrid supported for that...
Hi to All, I want to write a function which returns the string like 1st, 2nd, 3rd and etc by taking a number as input. For example --> if I give the input 78...
... vb.net Keep in mind that the File type in System.IO space is really stream based, so you have to think in those terms. Here is code to write, then read,...
... 3rd and ... 23rd. ... No built-in functions that I know of. I may have missed it in .NET though since I haven't had near as much experience in the...
Hi To open a file and read is very easy in VB.NET. you have to use Streamreader object. It just 3 line code. use the Imports System.IO (Namespace) Dim...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
