Comments by Member 11088078

Member 11088078 24-Nov-14 1:51am View

could you complete the answer? because it still Invalid use of group function, I think a have some error with my code Im using this combined with your code.....sum(CHAR_LENGTH(letter) - CHAR_LENGTH(REPLACE(GROUP_CONCAT(distinct(letter) SEPARATOR ', '), ',', '')) + 1)

Member 11088078 24-Nov-14 1:42am View

I appreciate your suggestion but, im just a beginner to do that procedure, I just need a simple query so that i can finish my project. thanks

Member 11088078 24-Nov-14 0:14am View

Invalid use of group function

Member 11088078 2-Oct-14 23:21pm View

Dim cmd As New OdbcCommand("INSERT INTO schemanetwork.table1(a,b,c) values('" & dt.rows(i).item("a").tostring() &"','" & dt.rows(i).item("b").tostring() &"','" & dt.rows(i).item("c").tostring() &"')where'" & dt.Rows(i).Item("a").ToString() & "' between '" & Trim(cmbfrom.Text.TrimEnd()) & "'And'" & Trim(cmbto.Text.TrimEnd()) & "'", ServerCN)

Im using this query but it is failed. can your correct it? this is my last problem please.

Member 11088078 2-Oct-14 23:14pm View

Finally done!, but one last question before i finish my question, what if I will add date range from column a because calumn a is date, i want to add in local connection, query like this "where a between 2014 and 2015"

Member 11088078 1-Oct-14 21:48pm View

You are inserting on column a only, can you insert it to column a, b, c. Or in all the columns

Member 11088078 1-Oct-14 20:25pm View

Amazing, your correct, but I want to collect all the data, Your code is getting 1 row only and specific column. I want to get all data from local the transfer to network like doing this -->all(*)method, is that possible?

Member 11088078 1-Oct-14 4:33am View

Could you give me an example so that I can understand what you mean.

Member 11088078 1-Oct-14 4:29am View

Dim sourceConnection As New OdbcConnection(callLocal())
Dim destinationConnection As New OdbcConnection(callNetwork())
Dim adapter As New OdbcDataAdapter("SELECT * from ft ", sourceConnection)
Dim insertCommand As New OdbcCommand("INSERT INTO tblcollected", destinationConnection)
How about this logic code?

Member 11088078 1-Oct-14 4:27am View

Im using this application for 1 client only, Im using connection string for local and network connections. in my database im using mysql 5.0

Member 11088078 1-Oct-14 4:16am View

I dont know how to use that, right now my application is runnung for localhost only, And also I can do that through network, but in my situation the router is not consistent so that im doing manual collect from local to server.

Member 11088078 1-Oct-14 4:11am View

In my schemalocal I have table table1 and columns name, middle, lastname. Same as in schemanetwork. so that im using this query as basis --> Insert into schemanetwork.table1 select * from schemalocal

Member 11088078 1-Oct-14 4:10am View

Deleted

In my schemalocal I have table table1 and columns name, middle, lastname. Same as in schemanetwork. so that im using this query as basis --> Insert into schemanetwork.table1 select * from schemalocal

Member 11088078 1-Oct-14 2:20am View

I want to apply it my application using vb.net, when I click the button my data in local host will transfer to my server network. Im doing this because our router is not consistent working. im using MySQL Administrator

Comments by Member 11088078 (Top 14 by date)