Search results for query: *

i have a xml-document like: <elem name=&quot;1&quot;> <elem name=&quot;1.1&quot;> <elem name=&quot;1.1.1&quot;> ... etc. Problem: the depth is NOT known. I want a list with all ancestors of the 'deepest' elem-element. Something like...

I use this query in a application. With mySQL it works fine (and fast). Access does NOT accept an &quot;ON clause&quot; with a reference to more than 2 tables, so that is my problem. What alternative can i use with Access??? example: SELECT ... FROM ((((Products AS P INNER JOIN...

I searched the Internet and looked into my SQL books, but could not find the answer, so i hope someone here can help me! I have a table like this (simplified): CREATE TABLE Products ( ProductId COUNTER CONSTRAINT ProductsPK PRIMARY KEY, ProductCode CHAR(8) NOT NULL, ParentId LONG...

Hi, Since a couple of days i am working with AccessXP and i am getting sadder every day.. Even some very simple queries do not work: Table tmp has 1 column 'id' with 28 rows Table H has also a column 'id' and 1778 rows. Now i want to join these tables with a VERY SIMPLE query: SELECT <fields>...

Hi, I am REALLY in trouble. I am working with Access 2002 and some simple queries do not work. (With other dbms they DO work). The error messages in Access are REALLY useless, so I am searching for the allowed SQL syntax. But it is NOT in the help files and i also cannot find it anywhere on the...

What's wrong with (Access2002): (FeatureClassId is a column of ProductClasses) UPDATE ProductClasses SET FeatureClassId=T.FeatureClassId FROM tmpProducts AS T WHERE ProductClasses.ClassId=T.ClassId; It is a very basic SQL-statement but Access gives a 'missing operator' error. And there is NO...

How to create a query/view by name in Access2002 with SQL? (so NOT via the GUI) This does NOT work: CREATE VIEW <view_name> AS SELECT ... neither does: CREATE PROC[EDURE] <procedure_name> AS SELECT ... Who knows???

Hi, I just switched from Access97 to Access2002 and I can NOT find any information about the allowed syntax (It was available in Access97 where you expect it: in the Help-files). Because i work most of the time with other databases this info is really important for me. Access supports the...

Hi, The following code does not work in Access (up to 2002): INSERT INTO <table> (<columnlist>) SELECT <columnlist> FROM <table> UNION SELECT <columnlist> FROM <table> UNION .... Who knows a alternative solotion (w/h temp. tables) Ronald

In Access (up to version 2002) this does NOT work: INSERT INTO <table> (<columnlist>) SELECT <columnlist) FROM <table> UNION SELECT <columnlist) FROM <table> UNION ... Does anybody know an solution to this problem? (I do not want to use temp tables!) Greetings Ronald