Type: Posts; User: RH+
Search took 0.02 seconds.
February 1st, 2013, 02:51 PM
Maybe I didnt explain something right
if I execute:
SELECT CG FROM CODE
the result is: '26022','26023','26024'
February 1st, 2013, 02:25 PM
I have a Mysql database with 2 tables:
clientes and code
clientes have a field called celda (index called CG)
and code have a field called CG (index called CG)
they have the same data type
March 21st, 2012, 09:28 PM
Don't answer this, im an idiot. After a long day making complex querys I couldnt resolve a simple:
group by name;
March 20th, 2012, 05:43 PM
I didnt know how to title this thread...
I have a table with name,a number and a date.
I need to get the date in wich, that number changed from zero from end to start.
I have ...
October 30th, 2011, 10:07 PM
Hi, im not sure if this is the best place to post this, if its wrong please move it.
I've been doing some things in VB6 and veeeery little in VB.NET (using 95% VB6 stuff, and only changing things...
September 3rd, 2010, 03:22 PM
Today they give me admin access for 5 minutes...they created the user and set "spanish" for language...it should be "English", corrected that. All working as it should.
Obviously they have to pay...
September 3rd, 2010, 09:28 AM
Before the re-installation and in all my projects it works with "/", I can edit all the SQLs statements, but Im trying to know what have change in the SQL server, and need to show that they triggered...
September 3rd, 2010, 08:34 AM
I'm using yyyy/mm/dd:
fechaInicio.Value = Format(DTPInicio.Value, "yyyy/MM/dd")
September 2nd, 2010, 10:30 PM
Thanks viperbyte, I'll try that tomorrow.
I Just look and see that they have change the collation too...I'll try resetting that to the previous value.
I can change anything of my DB but not a lot...
September 2nd, 2010, 08:56 PM
The problem seems to be that it needs now the dates in other format:
dd/mm/yyyy instead of YYYY/mm/dd...for the type of application I have dates everywhere, SPs, lots of queries, etc. I figured that...
September 2nd, 2010, 07:51 PM
September 2nd, 2010, 05:48 PM
I have one project running on a DB on MSSQL 2k, with other *big* 3rd party software.
2 days ago they have a problem with MSSQL, and for some reason instead of looking for the problem they installed...
August 17th, 2010, 09:59 AM
If I dont use the view the query is something like this, I know the view works and this query is VERY hard to follow =/
SELECT Leg.leg_numero as legajo,month(liq.liq_fecha) as...
August 16th, 2010, 06:57 PM
The query is:
Create view NAME(field1,field2)
AS select field1, field2 from table where condition
I dont think im having an error there. The database is user locked because is from a software...
August 16th, 2010, 11:14 AM
Im trying to use a system I developed for MSSQL in access doing the minimun amount of changes, in that SQL I have a view where I execute all queries, I'll try with other methods then...or just skip...
August 15th, 2010, 10:55 PM
I have a access file, and need to create a view from VB6.
This isnt working:
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\SJA068.mdb;Persist Security Info=False"
June 17th, 2010, 05:59 PM
Sorry for the bump, first and last time...I'm stuck with this =/
June 16th, 2010, 09:28 PM
I have a Datagridview, It will have pairs of lines:
first line: requested customer
second line: assigned quantity for that item for that customer
November 15th, 2009, 01:11 PM
I have this now:
connectionString="Data Source=***.**.***.**;Initial Catalog=test;User...
November 3rd, 2009, 11:03 PM
Sorry, That is what I have now :S sorry about not telling that before
I have the 2 connection strings, have the first query.
But dont know what to do with the result of the first query (sorry Im...
November 3rd, 2009, 10:36 PM
I have to query one table and insert the result in a table on another database in another server
The query is "select ID, name from Table"
The other table exists and have the same fields.
November 3rd, 2009, 08:25 AM
I like the temp table because this process is done 1 time each month, I think it will be better than go thought a datareader looking for elements from another datareader to do the inserts.
November 2nd, 2009, 07:46 AM
Databases are on different servers
And I need to be sure that the table with more records (its always the same DB) is Read Only.
So I need to copy the new items from that table to the other table....
November 2nd, 2009, 04:41 AM
That's works when the tables are from the same DB, this are from different DBs, so I have 2 connection strings and I cant do that in only one query (I think).
The tables fields are: IDClient,...
November 1st, 2009, 06:53 PM
I have 2 databases.
Table in database 1 has 5 fields
Table in database 2 has 15 fields
I made 2 querys that retrieve the 5 fields from the first and 5 fields from the second that are the same...
Click Here to Expand Forum to Full Width