Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

VFP - Cursor Operations: INSERT with single row without FROM clause #1658

Open
MarioV-GH opened this issue Dec 16, 2024 · 2 comments
Open

VFP - Cursor Operations: INSERT with single row without FROM clause #1658

MarioV-GH opened this issue Dec 16, 2024 · 2 comments

Comments

@MarioV-GH
Copy link

Describe the bug
Compiler error "MISSING FROM OR VALUES CLAUSE" with simple INSERT of one row.

To Reproduce
See attached examples

Expected behavior
Support vfp INSERT, e.g.:
INSERT INTO () VALUES ()
INSERT INTO () SELECT ... FROM

Screenshots
some_examples_insert_select

@hcasado
Copy link

hcasado commented Dec 30, 2024

Hola Mario, mucho gusto. Por tu nombre estimo que hablas español, soy nuevo en Xsharp, hasta ahora no pude utilizar sentencias SQL en Xsharp. Has podido usar SELECT * FROM nombre-tabla ?

@RobertvanderHulst
Copy link
Member

Hola Mario, mucho gusto. Por tu nombre estimo que hablas español, soy nuevo en Xsharp, hasta ahora no pude utilizar sentencias SQL en Xsharp. Has podido usar SELECT * FROM nombre-tabla ?

Hernan,
Mario is an international name. In this case Mario is from Austria.
To answer your question: in the current version SQL Select statements on DBF tables is not supported. This is planned for one of the next builds.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants