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...

thanks terry! very helpfull, i implemented celko's nested set approach. Works great!

tnx michael (again!) i do not have visio (i use smartdraw), can you post the query, it will be VERY helpfull for me, so thanks in advance!

tnx michael, i also tried the layered approach, but .. the query is VERY slow, so slow that it is not acceptable (for my client). The mySQL query is very fast (this query is against a 30+MB database). Ronald

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...

Thanks Steve, I am aware of your solution, but i do not want to use an extra query because i use access via odbc. Or is it possible to create the query outside Accees? I tried: CREATE VIEW <view_name> AS SELECT ... But that does also not work! BTW Why are so many people using Access, the GUI...

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