Syntaxerror in Designview -> How to correct wrong SQL-Syntax?

Adfra

Hi,

Situation is:
Used an embedded query which was "optimized" be Access with Brackets
("()" -> "[].").

Now problem is:
I get the error "Syntaxerro r in From part" in normal view as well as in
the design view. When I click ok -> Error and Window close.

How can I correct the error (=Seperate the two queries) when the design
window closes staight away once I click Ok on the error msg?

Thanks!
Frank

Nov 13 '05 #1

Subscribe Reply

1619

Beacher

Where is the SQL located again? on form load? or in the properties?

Nov 13 '05 #2

Adfra

Designed the query in the regular query designer and edited later the
sql of the query.

There is no connection to VBA, macros, Forms or reports. I'm talking
just the plain query. Everytime I try to open it in any view it gives
me the error and on "OK" it closes the error window as well as the
query.

Beacher schrieb:

Where is the SQL located again? on form load? or in the properties?

Nov 13 '05 #3

Ozzone

If you can view the query in design mode, then the syntax should be ok
even after you've edited it manually in SQL mode.

Nov 13 '05 #4

corey lawson

the query designer will modify this:

select * from
(select * from some_table...)

like you noted, into something bizarro when you go back into Designer
mode.

If you change the alias, or add your own alias like so:

select vx.* from
(select vz.* from some_table...) as vx

then, the first time you go back to Design mode, it will work, but if you
go back into SQL Edit mode and back to Design mode, it won't like it, so
you have to take out the square brackets that it put back in around the
subquery when you changed back to Design mode last time.

"Adfra" <ad******@gmx.d e> wrote in news:1118416892 .675551.52330
@g14g2000cwa.go oglegroups.com:

Hi,

Situation is:
Used an embedded query which was "optimized" be Access with Brackets
("()" -> "[].").

Now problem is:
I get the error "Syntaxerro r in From part" in normal view as well as in
the design view. When I click ok -> Error and Window close.

How can I correct the error (=Seperate the two queries) when the design
window closes staight away once I click Ok on the error msg?

Thanks!
Frank

Nov 13 '05 #5

Adfra

Thanks for your explanations, but I'm sorry to say that it does not
explain the solution to my problem.
Again, my problem is NOT how I have to correct the brackets.

THE PROBLEM IS: I can't modify my query anymore.

I can't access the query because it gets closed due to the Syntaxerror.
Do you have any idea how I could access the query anyway?

Nov 13 '05 #6

Similar topics

11832

SyntaxError: unqualified exec is not allowed in ... ?

by: j vickroy | last post by:

Could someone help me understand the following Python 2.3 error message: SyntaxError: unqualified exec is not allowed in function 'load' it contains a nested function with free variables in the following context: class Spam(object): pass class Spammer(object):

Python

1955

strange SyntaxError

by: Attila Szabo | last post by:

Hi, I wrote this sample piece of code: def main(): lambda x: 'ABC%s' % str(x) for k in range(2): exec('print %s' % k) main()

Python

4439

Visual Studio 2003 hangs up at start if I closed with a design viewactive

by: Jacobo Rodriguez Villar | last post by:

Hello, I have two problems with design view in VStudio 2003: First, if I close a solution with a form in design view, next time that I want start the vstudio, it hangs up before loading the project. I must remove the .vcproj file from the solution directory, start the vstudio, click ok on the error mesage about cant find .vcproj file, restore the .vcproj to it's original folder and reload the project into the ide

.NET Framework

1292

VB.NET Database DesignView

by: thowle | last post by:

Is there any simple way I can create a Design View for a Table in VB.NET.. For an example of what I need is in Microsoft Access.. when you create a new table, is has the field name, data type, description, etc. How can I do this in VB.NET, a datagrid and make my own data collection (That will be harder than I wish ;)). Are there any possibly 3rd part controls of this type.

Visual Basic .NET

24345

SyntaxError: can't assign to a function call

by: Fuzzyman | last post by:

What gives ? >>> a = >>> def f(): return a >>> f() >>> a.append(3) >>> f()

Python

1038

Absolute attribute in designview

by: dejavue82 | last post by:

Is there any reason not to use it? An asp.net programmer told me that it's bad practice, why?

ASP.NET

9889

try... except SyntaxError: unexpected EOF while parsing

by: oscartheduck | last post by:

I have a small script for doing some ssh stuff for me. I could have written it as shell script, but wanted to improve my python skills some. RIght now, I'm not catching a syntax error as I'd like to. Here's my code: #!/usr/bin/env python import sys

Python

1436

Is there a nicer way to do this?

by: Stefan Arentz | last post by:

Is there a better way to do the following? attributes = attributeNames = {} n = 1 for attribute in attributes: attributeNames = attribute n = n + 1

Python

23905

Python SyntaxError "Outside Function"

by: riverhorus | last post by:

I'm new to Python. I got this Python script from a friend. When I run it, I get an error message for line 7, "return None" saying "SyntaxError: 'return' outside function" Can someone explain what the SyntaxError is and how to fix it? Here's the block of script. The error occurs in line 7. def PC1(key, src, decryption=True): sum1 = 0; sum2 = 0; keyXorVal = 0; if len(key)!=16: print “Bad key length!”

Python

4315

SOAPpy SyntaxError

by: neridaj | last post by:

Hello, I'm going through the SOAP Web Services portion of Mark Pilgrim's tutorial and I'm getting this error when trying to build: python setup.py build Traceback (most recent call last): File "setup.py", line 8, in <module> from SOAPpy.version import __version__ File "/Users/username/Desktop/SOAPpy-0.12.0/SOAPpy/__init__.py",

Python

10426

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10154

The easy way to turn off automatic updates for Windows 10/11

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9029

AI Job Threat for Devs

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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6776

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5430

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5558

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4109

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3713

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2913

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General