Search results

Dear All, I have the following problem and I would be happy if somebody could help me with that: So far I had two tables. One contained customer orders, the other a description of each article. The connection between both tables was through a unique article name, which was the primary key of...

Asp / Asp.net May I also ask three very basic, maybe stupid questions with regards to this topic: 1. What is actually the difference between ASP and PHP with regards to integration of databases on websites? 2. Do you know a website, which is free, where I can use ASP or PHP? 3. Are there free...

There is an error message, which says (I have to translate it) that this in an unacceptable SQL command and that the programme expects a delete, insert, select or update query. Hmm, but why does the SQL code suggested by the website not work? Thank you. Diana

Thank you, but... Thank you!! Yes, that works. But how can I make check whether the new data doesn't already exist in the table? Do you also have an idea re the excel code? Diana

Hello, I have one question regarding the use of an INSERT INTO query. I tried the following code, which I found on http://www.techonthenet.com/sql/insert.php, however unfortunately it does not work. The text on the website says: “The use of the dual table allows you to enter your values in a...

Thank you. Both tables have the same columns, however one is the output of another programme, thus I cannot change it. However, linking the two tables is an easy way to solve the problem. Thank you very much for that hint. Diana

Problem solved. Thank you! Thank you neileg and DennisK for your contributions. Yes, tbY always exists and thus I can link the tables as suggested by neileg. BTW - when searching for some background on how to link tables I found this very helpful explanation...

Dear Forum, please let me ask a second question. I have two tables tbX and tbY, which both contain a column called "LastName". What I am looking for is a query or macro, which compares the columns "LastName" of tbX and tbY and then tells me, which items are contained in tbX but not in tbY. To...

Dear Forum, I have a question and I would be very happy if you could help me with some thoughts on how to start. I have a database, which contains one table tbX, which ist interesting in this context. tbX needs to be updated on a regular basis, hence it would be very helpful to automate this...