I'm creating a query, which I want to use in code in my VB.NET app.
This query produces the correct results when executed in Access:
SELECT tblEncounters.EncounterBeginDT, Query11.RID, Query11.LName,
Query11.FName, Query11.MI FROM tblEncounters INNER JOIN Query11 ON
tblEncounters.RID = Query11.RID;
Query11 looks like this:
SELECT tblCases.RID, tblCases.LName, tblCases.FName, tblCases.MI,
tblCases.TotalNum
FROM tblCases INNER JOIN [SELECT [tblRecipients].[RID],
[tblRecipients].[LName], [tblRecipients].[FName], [tblRecipients].[MI],
[tblEncounters].[Status], Count([Status]) AS TotComplete FROM
tblRecipients INNER JOIN tblEncounters ON
[tblRecipients].[RID]=[tblEncounters].[RID] WHERE
((([tblEncounters].[Status])=1)) GROUP BY [tblRecipients].[RID],
[tblRecipients].[LName], [tblRecipients].[FName], [tblRecipients].[MI],
[tblEncounters].[Status]]. AS Query8 ON (tblCases.TotalNum =
Query8.TotComplete) AND (tblCases.RID = Query8.RID);
Now to get the first query I have listed to work in code (i.e. to not
be referring to a named query in Access), I tried doing this:
SELECT tblEncounters.EncounterBeginDT, Query11.RID, Query11.LName,
Query11.FName, Query11.MI FROM tblEncounters INNER JOIN (SELECT
tblCases.RID, tblCases.LName, tblCases.FName, tblCases.MI,
tblCases.TotalNum FROM tblCases INNER JOIN [SELECT
[tblRecipients].[RID], [tblRecipients].[LName],
[tblRecipients].[FName], [tblRecipients].[MI],
[tblEncounters].[Status], Count([Status]) AS TotComplete FROM
tblRecipients INNER JOIN tblEncounters ON
[tblRecipients].[RID]=[tblEncounters].[RID] WHERE
((([tblEncounters].[Status])=1)) GROUP BY [tblRecipients].[RID],
[tblRecipients].[LName], [tblRecipients].[FName], [tblRecipients].[MI],
[tblEncounters].[Status]]. AS Query8 ON (tblCases.TotalNum =
Query8.TotComplete) AND (tblCases.RID = Query8.RID)) As Query11 ON
tblEncounters.RID = Query11.RID;
I get the message "SYNTAX error in FROM clause." For the life of me, I
cannot figure out where the error is at. I've done this sort of thing
before--create a query and use it in another query and then take the
SQL and do the "As Query. . ." (like I did for Query8).
What I'm trying to do is create a report that shows the number of
completed cases (not an Access report). A person can have multiple
encounters and an encounter is completed when the status field has a 1
in it. A case is considered complete for a person when ALL of their
encounters has a 1 in the status field so I compare the total number of
encounters a person has against the total number of encounters for a
person that has a 1 in the status field.
Any help would be appreciated.
Thanks.
Molly J. Fagan
Oklahoma Foundation for Medical Quality 21 2369
Well I can see a couple of errors in there
If you lay out SQL statements and use Aliases it becomes much easier to read
them and debug them so just laying out your SQL statement we get
SELECT
tblEncounters.EncounterBeginDT,
Query11.RID,
Query11.LName,
Query11.FName,
Query11.MI
FROM
tblEncounters
INNER JOIN
(
SELECT
tblCases.RID,
tblCases.LName,
tblCases.FName,
tblCases.MI,
tblCases.TotalNum
FROM
tblCases
INNER JOIN
[
SELECT
[tblRecipients].[RID],
[tblRecipients].[LName],
[tblRecipients].[FName],
[tblRecipients].[MI],
[tblEncounters].[Status],
Count([Status]) AS TotComplete
FROM
tblRecipients
INNER JOIN
tblEncounters
ON
[tblRecipients].[RID]=[tblEncounters].[RID]
WHERE
((([tblEncounters].[Status])=1))
GROUP BY
[tblRecipients].[RID],
[tblRecipients].[LName],
[tblRecipients].[FName],
[tblRecipients].[MI],
[tblEncounters].[Status]
]. AS Query8
ON
(tblCases.TotalNum = Query8.TotComplete)
AND
(tblCases.RID = Query8.RID)
) As Query11
ON
tblEncounters.RID = Query11.RID;
We can then see that
just after the second INNER JOIN line you've enclosed the SELECT
statement in [ ] instead of ( )
just after the closing ] (just before AS Query8) you have a spurious '.'
(full stop or period)
--
Terry Kreft
<mo****@hotmail.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com... I'm creating a query, which I want to use in code in my VB.NET app. This query produces the correct results when executed in Access:
SELECT tblEncounters.EncounterBeginDT, Query11.RID, Query11.LName, Query11.FName, Query11.MI FROM tblEncounters INNER JOIN Query11 ON tblEncounters.RID = Query11.RID;
Query11 looks like this:
SELECT tblCases.RID, tblCases.LName, tblCases.FName, tblCases.MI, tblCases.TotalNum FROM tblCases INNER JOIN [SELECT [tblRecipients].[RID], [tblRecipients].[LName], [tblRecipients].[FName], [tblRecipients].[MI], [tblEncounters].[Status], Count([Status]) AS TotComplete FROM tblRecipients INNER JOIN tblEncounters ON [tblRecipients].[RID]=[tblEncounters].[RID] WHERE ((([tblEncounters].[Status])=1)) GROUP BY [tblRecipients].[RID], [tblRecipients].[LName], [tblRecipients].[FName], [tblRecipients].[MI], [tblEncounters].[Status]]. AS Query8 ON (tblCases.TotalNum = Query8.TotComplete) AND (tblCases.RID = Query8.RID);
Now to get the first query I have listed to work in code (i.e. to not be referring to a named query in Access), I tried doing this:
SELECT tblEncounters.EncounterBeginDT, Query11.RID, Query11.LName, Query11.FName, Query11.MI FROM tblEncounters INNER JOIN (SELECT tblCases.RID, tblCases.LName, tblCases.FName, tblCases.MI, tblCases.TotalNum FROM tblCases INNER JOIN [SELECT [tblRecipients].[RID], [tblRecipients].[LName], [tblRecipients].[FName], [tblRecipients].[MI], [tblEncounters].[Status], Count([Status]) AS TotComplete FROM tblRecipients INNER JOIN tblEncounters ON [tblRecipients].[RID]=[tblEncounters].[RID] WHERE ((([tblEncounters].[Status])=1)) GROUP BY [tblRecipients].[RID], [tblRecipients].[LName], [tblRecipients].[FName], [tblRecipients].[MI], [tblEncounters].[Status]]. AS Query8 ON (tblCases.TotalNum = Query8.TotComplete) AND (tblCases.RID = Query8.RID)) As Query11 ON tblEncounters.RID = Query11.RID;
I get the message "SYNTAX error in FROM clause." For the life of me, I cannot figure out where the error is at. I've done this sort of thing before--create a query and use it in another query and then take the SQL and do the "As Query. . ." (like I did for Query8).
What I'm trying to do is create a report that shows the number of completed cases (not an Access report). A person can have multiple encounters and an encounter is completed when the status field has a 1 in it. A case is considered complete for a person when ALL of their encounters has a 1 in the status field so I compare the total number of encounters a person has against the total number of encounters for a person that has a 1 in the status field.
Any help would be appreciated.
Thanks.
Molly J. Fagan Oklahoma Foundation for Medical Quality
Terry
I'm confused.
In JET, I have used
[some select string]. AS name
to effect subqueries in SQL strings
for a long time. (I didn't invent this by any means, but I may have
championed it).
I believe that in T-SQL we can just use
(some select string) AS name
OP states that the query with []. AS name does work in Access.
So, can I assume that there is something in OP's post which indicated
he's not sending this query string to JET in his .NET application
(maybe it's just that: ".NET"?), or does .NET send ANSI SQL to JET and
[]. As name isn't allowed there or what?
I'm confused.
Oh, I already said that.
OK, I'm very confused!
Lyle,
The SQL I worked on was the one the OP had compounded to get rid of the
original query, I don't believe this is the one they stated was working in
Access I think the OP was referring to the first statements with respect to
this. In summary they aren't saying the SQL worked in Access and therefore
aren't saying the [] delimiter worked.
[] used to delimit a sub-query; I've not seen this before so I tested it, I
can't get it to work without error in either Access as a query or ADO, in
both cases an error is returned i.e.
"The Microsoft Jet database engine cannot find the input table or query
'SELECT * FROM YourTable'.
Make sure it exists and that its name is spelled correctly."
BTW 'SELECT * FROM YourTable' is the subquery text held in t [].
--
Terry Kreft
"lylefair" <ly***********@aim.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com... Terry
I'm confused.
In JET, I have used
[some select string]. AS name
to effect subqueries in SQL strings
for a long time. (I didn't invent this by any means, but I may have championed it).
I believe that in T-SQL we can just use
(some select string) AS name
OP states that the query with []. AS name does work in Access.
So, can I assume that there is something in OP's post which indicated he's not sending this query string to JET in his .NET application (maybe it's just that: ".NET"?), or does .NET send ANSI SQL to JET and []. As name isn't allowed there or what?
I'm confused.
Oh, I already said that.
OK, I'm very confused!
This works in Access 2003. (Works does not necessarily mean that it
does anything useful; it filters out matching records whose date in
Trans2 is before Jun 1, 2002 and could very well be effected in some
other way; but that's irrelevant to our question here.)
SELECT T.*,SubQuery.fldTransactionID
FROM Transactions T
LEFT JOIN
[SELECT fldTransactionID FROM Trans2 WHERE fldDate>=#6/1/2002#].
SubQuery
ON T.fldTransactionID = SubQuery.fldTransactionID
WHERE SubQuery.fldTransactionID IS NULL
My recollection is that the --- [sql string]. Alias --- was discovered
by someone while examining sql strings the query wizard/interface wrote
in response to some of his specifications; that person posted it to
CDMA, and gradually it became semi-popular.
This also works in Access 2003.
SELECT T.*,SubQuery.fldTransactionID
FROM Transactions T
LEFT JOIN
(SELECT fldTransactionID FROM Trans2 WHERE fldDate>=#6/1/2002#)
SubQuery
ON T.fldTransactionID = SubQuery.fldTransactionID
WHERE SubQuery.fldTransactionID IS NULL
My recollection is that it (the second sql string) did not work in JET
3.5, but I have no way of confirming that right now.
Reviewing this has given me a guess as to OPs problem. TTBOMK the
delimiters (square brackets or lower case tildes) for subqueries cannot
be nested.
TTBOMK Square Bracket Delimiters of/for in line SubQueries cannot be
nested. You state that it used to work; I wonder if the syntax was
exactly the same when it did.
"Terry Kreft" <te*********@mps.co.uk> wrote in
news:OZ********************@karoo.co.uk: Well I can see a couple of errors in there
If you lay out SQL statements and use Aliases it becomes much easier to read them and debug them so just laying out your SQL statement we get
SELECT tblEncounters.EncounterBeginDT, Query11.RID, Query11.LName, Query11.FName, Query11.MI FROM tblEncounters INNER JOIN ( SELECT tblCases.RID, tblCases.LName, tblCases.FName, tblCases.MI, tblCases.TotalNum FROM tblCases INNER JOIN [ SELECT [tblRecipients].[RID], [tblRecipients].[LName], [tblRecipients].[FName], [tblRecipients].[MI], [tblEncounters].[Status], Count([Status]) AS TotComplete FROM tblRecipients INNER JOIN tblEncounters ON [tblRecipients].[RID]=[tblEncounters].[RID] WHERE ((([tblEncounters].[Status])=1)) GROUP BY [tblRecipients].[RID], [tblRecipients].[LName], [tblRecipients].[FName], [tblRecipients].[MI], [tblEncounters].[Status] ]. AS Query8 ON (tblCases.TotalNum = Query8.TotComplete) AND (tblCases.RID = Query8.RID) ) As Query11 ON tblEncounters.RID = Query11.RID;
We can then see that just after the second INNER JOIN line you've enclosed the SELECT statement in [ ] instead of ( ) just after the closing ] (just before AS Query8) you have a spurious '.' (full stop or period)
That's valid Jet SQL for a "virtual table":
SELECT ...
FROM [SQL String]. As Alais
is completely valid.
However, for it to work, you have to make sure there are no
brackets
inside your SQL, and
While you accomplish the same thing with "() As" or "'' As" in
other
SQL dialects, Jet SQL is different.
I do on a daily basis exactly what you're saying is wrong.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
"Terry Kreft" <te*********@mps.co.uk> wrote in
news:5L********************@karoo.co.uk: The SQL I worked on was the one the OP had compounded to get rid of the original query, I don't believe this is the one they stated was working in Access I think the OP was referring to the first statements with respect to this. In summary they aren't saying the SQL worked in Access and therefore aren't saying the [] delimiter worked.
[] used to delimit a sub-query; I've not seen this before so I tested it, I can't get it to work without error in either Access as a query or ADO, in both cases an error is returned i.e. "The Microsoft Jet database engine cannot find the input table or query 'SELECT * FROM YourTable'. Make sure it exists and that its name is spelled correctly."
BTW 'SELECT * FROM YourTable' is the subquery text held in t [].
It doesn't work because you're leaving out part of the syntax, which
was correct in the OP's SQL:
SELECT ...
FROM [SQL]. As Alias
The period is required, and it must be right next to the closing
bracket.
This is standard Jet SQL and has been for a very long time.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
lylefair <ly***********@aim.com> wrote: My recollection is that the --- [sql string]. Alias --- was discovered by someone while examining sql strings the query wizard/interface wrote in response to some of his specifications; that person posted it to CDMA, and gradually it became semi-popular.
IRCC it was the way A2k "refomatted" some Querydef.SQL.
select * from (select * from t)
became
select * from [select * from t]. as [%$##@_Alias]
Supprisingly that funny syntax appeared to run in A97.
--
Paul
Ah right, you need some "whitespace" between the ]. and the alias.
You are quite right this does work.
That is horrible syntax though (IMO).
--
Terry Kreft
"lylefair" <ly***********@aim.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com... This works in Access 2003. (Works does not necessarily mean that it does anything useful; it filters out matching records whose date in Trans2 is before Jun 1, 2002 and could very well be effected in some other way; but that's irrelevant to our question here.)
SELECT T.*,SubQuery.fldTransactionID FROM Transactions T LEFT JOIN [SELECT fldTransactionID FROM Trans2 WHERE fldDate>=#6/1/2002#]. SubQuery ON T.fldTransactionID = SubQuery.fldTransactionID WHERE SubQuery.fldTransactionID IS NULL
My recollection is that the --- [sql string]. Alias --- was discovered by someone while examining sql strings the query wizard/interface wrote in response to some of his specifications; that person posted it to CDMA, and gradually it became semi-popular.
This also works in Access 2003. SELECT T.*,SubQuery.fldTransactionID FROM Transactions T LEFT JOIN (SELECT fldTransactionID FROM Trans2 WHERE fldDate>=#6/1/2002#) SubQuery ON T.fldTransactionID = SubQuery.fldTransactionID WHERE SubQuery.fldTransactionID IS NULL
My recollection is that it (the second sql string) did not work in JET 3.5, but I have no way of confirming that right now.
Reviewing this has given me a guess as to OPs problem. TTBOMK the delimiters (square brackets or lower case tildes) for subqueries cannot be nested.
Yes, Lyles explained it to me and it does work (although the OPs version
didn't) but Lyle's explained why he believes that to be so.
It's horrible syntax (IMO) and the fact that it doesn't work when embedded,
definitely makes it a poor choice.
--
Terry Kreft
"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:Xn**********************************@216.196. 97.142... "Terry Kreft" <te*********@mps.co.uk> wrote in news:5L********************@karoo.co.uk:
The SQL I worked on was the one the OP had compounded to get rid of the original query, I don't believe this is the one they stated was working in Access I think the OP was referring to the first statements with respect to this. In summary they aren't saying the SQL worked in Access and therefore aren't saying the [] delimiter worked.
[] used to delimit a sub-query; I've not seen this before so I tested it, I can't get it to work without error in either Access as a query or ADO, in both cases an error is returned i.e. "The Microsoft Jet database engine cannot find the input table or query 'SELECT * FROM YourTable'. Make sure it exists and that its name is spelled correctly."
BTW 'SELECT * FROM YourTable' is the subquery text held in t [].
It doesn't work because you're leaving out part of the syntax, which was correct in the OP's SQL:
SELECT ... FROM [SQL]. As Alias
The period is required, and it must be right next to the closing bracket.
This is standard Jet SQL and has been for a very long time.
-- David W. Fenton http://www.bway.net/~dfenton dfenton at bway dot net http://www.bway.net/~dfassoc
Yes, but in some versions of JET the horrible way was the only way to
approximate using a saved query in line.
Or it was the only way I knew! :-)
"Terry Kreft" <te*********@mps.co.uk> wrote in
news:Gm********************@karoo.co.uk: It's horrible syntax (IMO) and the fact that it doesn't work when embedded, definitely makes it a poor choice.
What do you mean it "doesn't work when embeded"?
It does work, perfectly well, as long as you remove all square
bracket from inside the subquery.
I use it *all the time*.
It's just a different dialect of functionality provided in every
major SQL dialect. All the other choices (parentheses or back single
quotes) also have their incompatibilities, since all the options
have meaning somewhere in each of the SQL dialects involved.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
"kaniest" <ka*****@xs4all.nl> wrote in
news:43***********************@news.xs4all.nl: lylefair <ly***********@aim.com> wrote: My recollection is that the --- [sql string]. Alias --- was discovered by someone while examining sql strings the query wizard/interface wrote in response to some of his specifications; that person posted it to CDMA, and gradually it became semi-popular.
IRCC it was the way A2k "refomatted" some Querydef.SQL.
select * from (select * from t)
became
select * from [select * from t]. as [%$##@_Alias]
Supprisingly that funny syntax appeared to run in A97.
The filter by form wizard writes that kind of SQL.
But I'm pretty sure it's documented in the Jet SQL help on
subqueries.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
David W. Fenton wrote: The filter by form wizard writes that kind of SQL.
But I'm pretty sure it's documented in the Jet SQL help on subqueries.
I can't find it; perhaps you could post the section containing it
togther with a reference as to the section's location.
I'm merely quoting Lyle, if he's wrong then you better start arguing with
him not me, personally I woudn't touch this syntax with a barge pole unless
it was forced on me.
Remove all square brackets; your doing a better job of convincing me it's
horrible syntax.
--
Terry Kreft
"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:Xn**********************************@216.196. 97.142... "Terry Kreft" <te*********@mps.co.uk> wrote in news:Gm********************@karoo.co.uk:
It's horrible syntax (IMO) and the fact that it doesn't work when embedded, definitely makes it a poor choice.
What do you mean it "doesn't work when embeded"?
It does work, perfectly well, as long as you remove all square bracket from inside the subquery.
I use it *all the time*.
It's just a different dialect of functionality provided in every major SQL dialect. All the other choices (parentheses or back single quotes) also have their incompatibilities, since all the options have meaning somewhere in each of the SQL dialects involved.
-- David W. Fenton http://www.bway.net/~dfenton dfenton at bway dot net http://www.bway.net/~dfassoc
Terry Kreft wrote: I'm merely quoting Lyle, if he's wrong then you better start arguing with him not me
Thanks A LOT, Terry! Couldn't you just have sent me a shrapnel bomb in
the post?
David W. Fenton <dX********@bway.net.invalid> wrote: "kaniest" <ka*****@xs4all.nl> wrote in select * from [select * from t]. as [%$##@_Alias]
Supprisingly that funny syntax appeared to run in A97.
The filter by form wizard writes that kind of SQL.
Filter by form seems to work on tables with identifiers
that need brackets. Tell us more, so we can find out how.
--
Paul
Oh, you haven't got that yet then ?
Sorry Lyle, I was more concerned with attribution than retribution <g>.
--
Terry Kreft
"lylefair" <ly***********@aim.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com... Terry Kreft wrote: I'm merely quoting Lyle, if he's wrong then you better start arguing with him not me
Thanks A LOT, Terry! Couldn't you just have sent me a shrapnel bomb in the post?
"Terry Kreft" <te*********@mps.co.uk> wrote in
news:CZ********************@karoo.co.uk: "lylefair" <ly***********@aim.com> wrote in message news:11*********************@g47g2000cwa.googlegro ups.com... Terry Kreft wrote: I'm merely quoting Lyle, if he's wrong then you better start arguing with him not me
Thanks A LOT, Terry! Couldn't you just have sent me a shrapnel bomb in the post?
Oh, you haven't got that yet then ?
Sorry Lyle, I was more concerned with attribution than retribution <g>.
Lyle and I are in agreement on this one. These kinds of subqueries
are quite useful.
I was doing some work with MySQL 4.0.1 today and wishing to hell
that I was able to do just that (MySQL's variant of SQL can't do
domain aggregates on non-grouped filtered recordsets).
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
It's nice to know it's a problem solver, as I said before though from your
and Lyle's comments I wouldn't use this syntax unless I was forced to.
--
Terry Kreft
"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:Xn**********************************@216.196. 97.142... "Terry Kreft" <te*********@mps.co.uk> wrote in news:CZ********************@karoo.co.uk:
"lylefair" <ly***********@aim.com> wrote in message news:11*********************@g47g2000cwa.googlegro ups.com... Terry Kreft wrote: I'm merely quoting Lyle, if he's wrong then you better start arguing with him not me
Thanks A LOT, Terry! Couldn't you just have sent me a shrapnel bomb in the post?
Oh, you haven't got that yet then ?
Sorry Lyle, I was more concerned with attribution than retribution <g>.
Lyle and I are in agreement on this one. These kinds of subqueries are quite useful.
I was doing some work with MySQL 4.0.1 today and wishing to hell that I was able to do just that (MySQL's variant of SQL can't do domain aggregates on non-grouped filtered recordsets).
-- David W. Fenton http://www.bway.net/~dfenton dfenton at bway dot net http://www.bway.net/~dfassoc
I think that because of Access/Jet's capability of using saved queries
in other queries that it's unlikely ever to be necessary.
One of the things I've found it helpful for is explaining things here;
by using it we can show a query string, more or less, in its entirety,
without the sort of black box placeholder of a (sub) query name. I know
we can show the SQL of these sub queries in an additional paragraph,
but when we read these we may have to go back and forth between the two
entries a lot before we understand them.
Regardless its time has passed and has been for a few years if I am
right in thinking that JET 4.0 enabled the use of round brackets for
sub query strings. And I would classify this as a good thing as it
brings the syntax into line with other SQL standards. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: signaturefactory |
last post by:
I am trying the following query in and oleDbCommand:
SELECT PartLocations.LocationName, Sum(PartsJournal.Quantity) AS
SumOfQuantity, PartsJournal.PartsLotNumber
FROM PartLocations INNER JOIN...
|
by: JJA |
last post by:
Please advise on how to get the GROUP BY coded in an acceptable way:
DECLARE @LO INT
DECLARE @HI INT
DECLARE @StartDate varchar(10)
DECLARE @EndDate varchar(10)
SELECT @StartDate =...
|
by: Andrew McNab |
last post by:
Hi folks,
I have a problem with an MS Access SQL query which is being used in an
Access Report, and am wondering if anyone can help.
Basically, my query (shown below) gets some records from a...
|
by: Andrew McNab |
last post by:
Hi folks,
I have a problem with an MS Access SQL query which is being used in an
Access Report, and am wondering if anyone can help.
Basically, my query (shown below) gets some records from a...
|
by: dskillingstad |
last post by:
I'd appreciate any help I can get. I'm not sure what I'm doing wrong,
but....
I've searched these groups for some solutions but no luck.
I have an unbound form (frmSearch), with several unbound...
|
by: Lee |
last post by:
Hello All,
First of all I would like to say thank you for all of the help I have
received here. I have been teaching myself Access for about 4 years
now and I've always been able to find a...
|
by: Sean Shanny |
last post by:
To all,
We are running postgresql 7.4.1 on an G5 with dual procs, OSX 10.3.3
server, 8GB mem, attached to a fully configured 3.5TB XRaid box via
fibre channel.
I think we have run into this...
|
by: MP |
last post by:
vb6,ado,mdb,win2k
i pass the sql string to the .Execute method on the open connection to
Table_Name(const) db table
fwiw
(the connection opened via class wrapper:)
msConnString = "Data Source="...
|
by: HC |
last post by:
Hello, all, I started out thinking my problems were elsewhere but as I
have worked through this I have isolated my problem, currently, as a
difference between MSDE and SQL Express 2005 (I'll just...
|
by: amitabh.mehra |
last post by:
Hi
I havent used MQT before. Read the online tips and tutorials but none
seems to give any hint for my problem.
I have a base table (base_table) as:
st varchar(25) default...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |