Search:
Type: Posts; User: Mustaphi
Search:
Search took 0.03 seconds.
-
Million thanks Olaf
it works like a charm
-
Thank you ChrisE
I 'll try it tomorrow
-
Thank you ChrisE
But as jpbro explained I want the first word of each row without numbers or dash..
In the database some data start are like this:
1- aaaaa bbbbb
2- ccccc ddddd
etc
Others are...
-
Could you modify the code using this technique?
-
Thank you very much gentelmen
INSERT INTO Tbl2 (Column1) SELECT CASE WHEN INSTR(LTRIM(Column1), ' ')=0 THEN Column1 ELSE SUBSTR(Column1, 1, INSTR(LTRIM(Column1), ' ')) END FROM Tbl1;
This code...
-
Arnoutdv and jpbro
Thanks a lot for you interest
INSERT INTO Tbl2 (Column1) SELECT CASE WHEN INSTR(Column1, ' ')=0 THEN Column1 ELSE SUBSTR(Column1, 1, INSTR(Column1, ' ')) END FROM Tbl1;...
-
Hello Vbforums
I'm trying to copy one column from one table and insert it in another column of a new table.
INSERT INTO Tbl2([Column1])" & _
"SELECT Clumn1 FROM Tbl1
But I need to...
-
Some years ago, I was able to send mails.
Now, I get errors using the same applications.
-
189924
189922
189923
189925
I'm getting either of these messages
Me too
but I no longer be able to send emails now
-
I tested all of them but I failed to make anyone works
-
-
Hello Vbforums community
I want to ask if there is a viable method for sendig email
I tested many demos that I found on the net but none of them is working.
thanks
-
Hello VbForums
I"m saving the path of my pictures in database.
E:\my pics\Pics\Image 10.jpg
Now I need to change the path of all my pictures to:
C:\Program Files (x86)\Log_pics\MyPics\...
-
thanks but I need a query like this:
SQL = "Select * From myTable Where Firstname = '" & Text1.text & "'"
-
Olaf
You are great
your query worked.
But for a spcial purpose I wonder if it is possible to use a a query like this.
SQL = "Select * From myTable Where Firstname = '" & Text1.text & "'"
I...
-
thank you all for your interest and help
-
Hello VbForums community
I'm using sqlite as database.
When I'm trying to retrieve some strings that contain apostrophe (') from database, the applcation freezes.
Is there a workaround to overcome...
-
During the process of installing the application I get a message error like:
impossible d'enregisrer l'objet com(ActiveX)
C:\Windows\system32\MSCOMCTL.OXC
echec dans Loadlibrary (126)
-
thank you all
But still no one told me why these ocx and dlls refuse to be installed on this special machine.
IS there a way to force windows to accept installing these dlls in system32 or ...
-
I'm not sure but I think it is 64 bit
-
I'm using Setup Factory installer
-
Hello VbForums
On one of my clients system (W10 professional) I was unable to install VB6 common controls on system 32.
I tried to copy them manually but impossible to register them by means of...
-
-
thanks but is it possible to check if a file is copied on the root of the drive ?
-
Hello VbForums
As the title indicates
Is it possible to know if a file is saved at the root of the hard drive?
I want the user to save the file in a folder.
If the user saves the file at the of...
-
What i mean by line is not row
My fielld is text_type
it looks like this:
le: xxxxxxxxxxx
aaaaaaaaaaaaaaa
bbbbbbbbbbbbbb
cccccccccccccccc
The 1st line begins with "Le:"
The second line is...
-
Would please show me how to do that?
-
Hello VbForums community
I want Vforums experts to help me in this point.
I need to copy data from one field to another one except the two first lines.
Cn.Execute "update Tbl1 set Result = '"...
-
It seems what I'm trying to reach is not possible
-
It seems complicated because Tbl1 may also have another join with a fourth table.
-
I need to display on a listview the name of the item (Main table) and other info in Tbl1 and Tbl2.
-
thank you sir
You are great
the code worked very well using two tables.
But I still have one small issue.
I have a third table (The Parent Table)
How to include this table in the code above.
...
-
Thank you sir for your interest
I tested your code
I'm getting errror
A join is required efore on
Besides, I cannot use Limit because "Due" may have more than one occurence.
Cnn.Execute...
-
Hello experts
I'm using Sqlite3 and RC5
My tables look some how like these:
Set Cnn = New_c.Connection(, DBCreateInMemory)
Cnn.Execute "Create Table Tbl1(Item_ID Integer, BrandID Integer)"...
-
Thank you Moderator
I still want to do it.
SQL = "Select * from Item_tbl Where item_name =? "
Set Rs = Cnn.OpenRecordset(SQL)
With Cnn.CreateSelectCommand(SQL)
.SetText 1,...
-
Hello
My table sqlite has 8 records.
When I delete the first record then I add a new record , the new record takes an ID = 9.
Is there a way that the new added record takes the ID of the deleted...
-
-
thank you Eduardo
please let us know once the bug is fixed
-
Hello Eduardo
I'm using your excellent BSPrinter printer to print my flexgrid.
My only issue is Right alignement.
The text in the grid is left aligned though I'm using Right to left property.
Am...
-
Hello VbForums
I use Krool's VbFlexgrid .
On the form it shows Right to left
I mean the "record Name " in the first column.
but when I print , it is sorted Left to Right.
The "record Name " is...
|
Click Here to Expand Forum to Full Width
|