Say field2 contains the text you said....here is the query...
update table1 set field2 =
replace(field2, 'beginner','New User')
where field2 like '%beginner%';
The where clause is not required i think.
Garimella
Last Activity: Mar 2 '07, 05:41 AM
Joined: Jan 12 '07
Location:
-
concatenate values from different rows
Hi Experts.
Need a help in writing a query. Here is the scenario.
table has three columns : Emp Id, Book Name, Book Number
sample data is......
1 ten 1
1 two 2
1 Thr 3
2 Tss 1
2 ans 2
Query output should be like this
1 ten two thr
2 Tss ans -
in the order of Emp Id, Book name1, book name2, book name3.
regards.
... -
Unwanted characters in file.
Hi
I've created a text file with records from the tables in access to a file using PUT function. There are few line in the file that are coming with "NUL(^@=0=0 x0)" shown as blank spaces,at the start which makes my file go out of format. Can someone please help me on this? I don't want these characters to be on the file. Does this have any thing to do with the length of the string defined.
Regards,
Vinay -
Hi Killer42,
Thank you very much for the help. I solved it yesterday itself. Yes it was because of the definition of length. It was declared as 600 characters whereas the final output has 619 characters. That's not the end of the story.. i've one more issue. Now few records are having lot of spaces inthe front because of which the file looks unorganized. can you please help me. it's looking like this.
...Code:Leave a comment:
-
Bad Length error - Very Urgent
Hi
When I'm trying to write data to a file from a custom variable(contai ns group of string items) it is giving me Runtime Error 59: bad record length.
Put #1, , ee_rec20 --this is the line which is giving the error
Kindly respond to this. I've to generate the file in an hour, please.
Regards,
Vinay -
Varchar to Integer Typecast
I need to convert a varchar to Integer to compare if it is in the range. The problem is there might be few rows which have characters in them instead of numbers. This column either contains a number like '01','04', '15' etc or say a name. How can i achieve this? Is it possible. -
Hi
I tried db=CurrentDb(), but it didn't work it's still giving that error. I've checked the project references, they are fine. This was running fine until Jan 10th. I don't why this started giving this error. I'm trying to run this query manually, not from the code, even then it's giving the same error. I've been trying to fix it for the last 10days but i couldn't, Please help me if there are any other things that does cause this...Leave a comment:
-
hi
This is related to your suggestion for Invalid procedure call in ms access. I tried by setting it as a new datbase but it's giving an error ' wrong usage of New keyword'. here is the snipet(original ) of the code used. please let me know where to modify.
...Code:Dim db As Database Dim rst As Recordset Set db = DBEngine(0)(0) Set rst = db.OpenRecordset("select * from qrySelect_CostDifferences",Leave a comment:
-
Runtime Error5 :Invalid Procedure Call
When i'm trying to exute a piece of code it's giving this error. Please help me on this. i'm in desperate need of this.
Code snippet:
dim rst as recordset
dim db as database
Set rst = db.OpenRecordse t("select * from qrySelect",dbOp enSnapshot)
No activity results to display
Leave a comment: