That’s v14 look at 13 doc which is where I got it from
Regards
Chuck
On Mon, Sep 17, 2018 at 6:46 PM Chip Scheide via 4D_Tech <
4d_tech@lists.4d.com> wrote:
> Chuck,
> Thanks but...
>
> http://livedoc.4d.com/4D-SQL-Reference-14/Syntax-rules/primary-key-definition.300-119839
Chuck,
Thanks but...
http://livedoc.4d.com/4D-SQL-Reference-14/Syntax-rules/primary-key-definition.300-1198391.en.html
Says:
[CONSTRAINT sql_name] PRIMARY KEY (sql_name, ... , sql_name)
example:
CREATE TABLE Customer
(SID int32,
Last_Name varchar(30),
First_Name varchar(30),
PRIMARY KEY (SID
I think it should be
ALTER TABLE [Anmlprot_File_Link]
ADD [Journal_Key] [Primary KEY]
This is from the 4D docs
ALTER TABLE sql_name
{ADD column_definition [PRIMARY KEY] [TRAILING] |
DROP sql_name |
ADD primary_key_definition |
DROP PRIMARY KEY |
ADD foreign_key_definition |
DROP CONSTRAINT sql_n
I missed th v13 part. Is the field already set as indexed and unique. If not I
would bet alter table would not work. I do not know what would happen in newer
versions if you tried to assign UUID inside 4D without it being a UUID field
Have you tried other data types.
Regards
Chuck
---
n, Sep 17, 2018 at 3:49 PM Chip Scheide via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>> trying to set a new field in a new table as primary key
>>
>> $SQl_Command:="ALTER TABLE [Anmlprot_File_Link] ADD PRIMARY KEY
>> (Journal_Key)"
>>
>
ink] ADD PRIMARY KEY
> (Journal_Key)"
>
> Begin SQL
> Execute Immediate : $Sql_Command
> end SQL
>
> table : [Anmlprot_File_Link] exists
> Field : Journal_Key exists as a field in [Anmlprot_File_Link]
>
> Journal_Key defined as: String 255, Unique, Indexed, Nu
trying to set a new field in a new table as primary key
$SQl_Command:="ALTER TABLE [Anmlprot_File_Link] ADD PRIMARY KEY
(Journal_Key)"
Begin SQL
Execute Immediate : $Sql_Command
end SQL
table : [Anmlprot_File_Link] exists
Field : Journal_Key exists as a field in [Anmlprot
What does it mean when a method suddenly starts getting a runtime error in a
compiled database that says
Remote SQL Server is not available
The line number it gives is the End SQL line in the method.
The SQL code is a simple
SELECT field1, field 2 from table where (field3
-
Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
Informed Solutions, Inc.
Brookline, MA 02446 USA Registered 4D Developer
Providers of 4D, Sybase & SQL Server connectivity
http://w
I’m transferring data between two 4D server systems. One table contains Lab
reports which are formatted from a block of HL7. The records contain the raw
HL7 and a 4D Write letter which is the lab report. There could,instead, be a
PDF report in a blob.
There is also a table of consult letters th
Thanks, Tim.
> On Aug 6, 2018, at 5:27 PM, Timothy Penner via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
>> So, how do I make the SQL case-insensitive?
>
> http://doc.4d.com/4Dv16R5/4D/16-R5/Database-Parameters.302-3480842.en.html
>
> Set Database Param
> So, how do I make the SQL case-insensitive?
http://doc.4d.com/4Dv16R5/4D/16-R5/Database-Parameters.302-3480842.en.html
Set Database Parameter (SQL Engine case sensitivity) = selector 44
-Tim
**
4D Internet Users Group
So, how do I make the SQL case-insensitive?
> On Aug 6, 2018, at 4:57 PM, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> 4D query is case insensitive whereas SWL by default is not.
>
>
>
> **
4D query is case insensitive whereas SWL by default is not.
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr..
4D v15
I run the following code: The SQL Login goes to the database that is running.
DA_SQL_Login2
C_TEXT(tLookFor)
tLookFor:="%Mc%"
ARRAY TEXT(aFoundNames;0)
ARRAY TEXT(aFoundPhones;0)
Begin SQL
Select FullName, Phone FROM PatientBase WHERE (FullName like :tLookFor) INTO
:a
=:1
> On Jul 28, 2018, at 1:44 PM, Illustration House via 4D_Tech
> <4d_tech@lists.4d.com> wrote:
>
> Did you mean =:or:=in the following line:
>
> ("ItemID=:1";$tItemID)
**
4D Internet Users Group (4D iNUG)
Arch
Did you mean =:or:=in the following line:
("ItemID=:1";$tItemID)
Roger T. Reed
> On Jul 27, 2018, at 3:41 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> Jeff,
> You know - something wrong. ;-/
>
> Maybe a control char? Chars outside of regular ascii? If it's po
Jeff,
You know - something wrong. ;-/
Maybe a control char? Chars outside of regular ascii? If it's possible this
value could have been pasted in from some external text it might have some
wonky char in it that looked pretty but chokes here. It's happened to me.
May be impossible there. Agreed it'
> On Jul 27, 2018, at 1:52 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> It's also annoying that an error handler is running, yet a runtime error
> appears instead of calling the error method. Also the lack of a call chain
> makes this really hard to track down.
So. Incredi
also annoying that an error handler is running, yet a runtime error
appears instead of calling the error method. Also the lack of a call chain
makes this really hard to track down.
It failed once in two days (this is a "workhorse" method that gets called all
the time). The old Be
Randy,
I'd add a check to the item ID string. ORDA is excruciatingly picky in
terms of inputs. I bet something is not completely kosher in an item id and
that's causing the RT error.
Alternatively you could loop through the list of items and check the id
there. But if the param is generated or use
It looks like ORDA may be 99.9% reliable, just like 4D SQL.
I just had my first random, no explanation runtime error from a method I
converted from SQL to ORDA. The code has been live for a day and a half - looks
like it failed sometime early in day 2.
The code:
C_TEXT($0;$tManufacturer
Tim & Anyone Else,
I got it working using the following:
vt_temp1:="2018-04-06 11:09:00 AM"
vt_temp2:="2018-04-06 11:12:00 AM"
Begin SQL
SELECT RecordID, Mach_ID, Energy_1, Energy_2, Energy_3
FROM DMM_TTX_HISTORIAN
WHERE [TimeStamp] >
*
-Original Message-
From: Timothy Penner [mailto:tpen...@4d.com]
Sent: Tuesday, July 10, 2018 3:09 PM
To: s.o...@the-aquila-group.com; '4D iNug Technical' <4d_tech@lists.4d.com>
Subject: RE: SQL Statement Assistance
That looks like the field is just plai
Justin,
Thanks...
I've done that multiple times and nada. The error being returned by the driver
is that it says you can't convert an "ntext" to "timestamp":
Error Desc = Error #206 (Operand type clash: ntext is incompatible with
datetim)
I did not des
That looks like the field is just plain text; have you tried just removing the
extra single quotes from the text variable in your initial example (Justin Will
also suggested this)?
vt_temp1:="04/06/2018 07:58:00 AM"
vt_temp2:="04/06/2018 08:01:00 AM"
Begin SQL
Hi Steve,
First can you do a sql call and add timestamp to return. Use cast as VARCHAR
Begin SQL
SELECT RecordID, Mach_ID, Energy_1, Energy_2, Energy_3, TimeStamp
FROM DMM_TTX_HISTORIAN
WHERE cast(TimeStamp as VARCHAR) >= '04/06/2018 07:58:00 AM'
AND cast
Steve
Try removing the single quotes in your text variable assignment and retry your
initial example.
Justin
**
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Tim,
This is a MS SQL server database and it queries just fine using a static
timestamp value, as shown below:
Begin SQL
SELECT RecordID, Mach_ID, Energy_1, Energy_2, Energy_3
FROM DMM_TTX_HISTORIAN
WHERE TimeStamp >= '04/06/2018 07:58:00 AM'
AND TimeStamp <
There may be multiple things wrong here;
First, is your field actually named TimeStamp?
If so, this is a SQL Reserved word and shouldn’t be used as a field identifier.
Let's start with that first.
-Tim
**
4D Internet
Tim,
I tried the following with no success:
vt_temp1:="{ts '2018-04-06:58:00'}"
vt_temp2:="{ts '2018-04-08:01:00'}"
Begin SQL
SELECT RecordID, Mach_ID, Energy_1, Energy_2, Energy_3
FROM DMM_TTX_HISTORIAN
WHERE
iNug Technical <4d_tech@lists.4d.com>
Subject: RE: SQL Statement Assistance
How about?
- Using the TS syntax as described here:
http://kb.4d.com/assetid=75947
- Using CAST to cast the TEXT as a Timestamp:
http://doc.4d.com/4Dv15/4D/15/CAST.300-2288162.en.html
http://kb.4d.com/assetid=75047
How about?
- Using the TS syntax as described here:
http://kb.4d.com/assetid=75947
- Using CAST to cast the TEXT as a Timestamp:
http://doc.4d.com/4Dv15/4D/15/CAST.300-2288162.en.html
http://kb.4d.com/assetid=75047
- Using a C_DATE variable instead of a _CTEXT variable
-Tim
*
Hoping someone can point me in the right direction regarding querying a
date/time field in a SQL database:
I built the following query for testing purposes and it works just fine,
returning the correct results:
Begin SQL
Hi All,
Has anyone done this. I am looking to select some data from a table and import
into customer 4D database so as to mark invoices paid.
Is the driver only available for windows or is there a UNIX version that can be
used on a MAC
Thanks and regards
Chuck
--
Chuck
Re: SQL LOGIN(“IP:ipaddress:port:ssl”;"user”;"Userpassword";*)
That did it. Thanks!
Steve
> On 9 May 2018, at 21:50, Charles Miller via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> Try adding the port to ip address and I always connect using IP not D
Try adding the port to ip address and I always connect using IP not DB so
connection would look like 192.168.5.12:19812
Regards
Chuck
On Wed, May 9, 2018 at 4:47 PM, Stephen Shaw via 4D_Tech <
4d_tech@lists.4d.com> wrote:
>
>
> Chuck
>
> Thanks for answering
>
> S
Chuck
Thanks for answering
SQL is running and shows the active connection when the code is run from the
client
I have just copied the code to a single user database and I am on the same
network and subnet
Steve
> On 9 May 2018, at 21:24, Chuck Miller via 4D_Tech <4d_tech@lists.
Are you sure that
1. SQL server is running
2. you are trying to connect to same place
Regards
Chuck
Chuck Miller Voice: (617) 739-0306
Informed Solutions, Inc. Fax: (617) 232-1064
Hi all
I get an error when using the sql login command from 4D Developer from a stand
alone database, but not from a 4D client
SQL LOGIN(“4D:DatabaseName”;"user”;"Userpassword";*)
If (ok=1)
ALERT("Success”) // works on 4d client attached to the database
. In Oracle, for
example, you can do the following to create a date:
To_Date(‘2018-05-07’,’-MM-DD’)
or to subtract days:
SYSDATE -3 (you can also use fractions of days)
or to add months:
ADD_MONTHS(SYSDATE,2)
But 4D SQL has nothing like these. This seems like a big
lues from one type to
> another.
http://doc.4d.com/4Dv16R6/4D/16-R6/4D-SQL-engine-implementation.300-3628406.en.html
in other words, you can't expect 4D to implicitly convert numeric 2 to
TIMESTAMP.
besides, with an expression such as
Select someDate - 2
it is unclear whether you w
What kind of date math does 4D’s SQL support? The following gives an error
where I’m trying to subtract 2 days from the date:
Select someDate - 2
From someTable
The error returned is “Operation VK_TIME - VK_LONG8 is not type safe. Failed to
validate SELECT command.”
Same thing if you put that
Thanks Jeff
Uist
On 03/05/2018 15:06, Jeffrey Kain via 4D_Tech wrote:
Just ignore it - I've seen this happen before even on perfectly valid SQL
statements pointed to 4D's own engine.
**
4D Internet Users Group (4D
Just ignore it - I've seen this happen before even on perfectly valid SQL
statements pointed to 4D's own engine.
Sometimes you can tweak a line or two in the statement and the error triangle
icon will go away.
--
Jeffrey Kain
jeffrey.k...@gmail.com
> On May 3, 2018, at
Hi
I am developing a V16.6 app which uses MSSQL as the backend database.
I have a slight problem in that I am storing Unicode in NVARCHAR fields which
4D indicates is a syntax error next to the line, although it actually works
fine in practice.
The app compiles OK.
Is this something I can fix,
I’ve got some SQL code that I am running to create new fields in tables. Basic
"ALTER TABLE tablename ADD fieldname VARCHAR” command. It is working just fine.
But I would like to also set the "Map NULL values to blank values” checkbox
property. Can you do this programmatically? I
Miyako,
This worked, thanks!:
SET DATABASE PARAMETER(SQL engine case sensitivity;0)
--
Message: 1
Date: Mon, 19 Feb 2018 20:58:10 +
From: Keisuke Miyako
To: 4D iNug Technical <4d_tech@lists.4d.com>
Subject: Re: U
have you tried
SET DATABASE PARAMETER(SQL engine case sensitivity;0)
http://doc.4d.com/4Dv16/4D/16.3/SET-DATABASE-PARAMETER.301-3651635.en.html
there is also a database setting
http://doc.4d.com/4Dv16/4D/16.3/SQL-page.300-3670701.en.html
> On Feb 20, 2018, at 03:20, David Rose via 4D_T
This 4D Query will return records with Last_Name containing both "u" and "ü":
QUERY([Donors];[Donors]Last_Name="@u@")
This SQL query will only return records with Last_Name containing "u"
Begin SQL
SELECT Last_Name
FROM Donors WHERE Last_N
Jeffrey Kain
jeffrey.k...@gmail.com
> On Jan 23, 2018, at 10:44 AM, Tony Ringsmuth via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> I’ve been asked if 4D SQL supports CASE statements.
*
Yes.
http://doc.4d.com/4Dv15/4D/15/case-expression.300-2288083.en.html
--
Jeffrey Kain
jeffrey.k...@gmail.com
> On Jan 23, 2018, at 10:44 AM, Tony Ringsmuth via 4D_Tech
> <4d_tech@lists.4d.com> wrote:
>
> I’ve been asked if 4D SQL suppor
I’ve been asked if 4D SQL supports CASE statements.
I don’t see it in the docs: but does anyone know definitively?
Thanks,
--
Tony Ringsmuth
Business Brothers Inc.
763-420-8686
**
4D Internet Users Group (4D iNUG
Thanks, I'll try that...
Jim Dorrance
jim.dorra...@gmail.com
4...@dorrance.eu
www.4d.dorrance.eu
PS: If you know of anyone that needs an experienced 4D programmer to add
energy and experience to their team, please let me know. I have
experience in many areas. Reasonable rates. Remote or Paris onl
.
It is somewhat complicated to implement, but provide a seamless interface for
scrolling large record sets without loading everything into memory.
John DeSoi, Ph.D.
> On Jan 23, 2018, at 7:22 AM, Jim Dorrance via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> What I am doing now
What I am doing now is
Begin SQL
SELECT * FROM [myTable] LIMIT 1 into LISTBOX :myListbox;
End SQL
if Records in table > 1 I then fill the rest of the arrays manually
starting at goto record (1) on successive outside calls
Any other ideas?
--
Jim Dorrance
jim.dorra...@gmail.co
Anybody have some hints how I could I fill a list box progressively (
LIMIT? OFFSET),
or a demo DB...
Thanks,
Jim
On Mon, Jan 22, 2018 at 7:30 PM, Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:
> Not so dissimilar from your idea but you could do
>
> Begin SQL
>
Thank you. Perfect.
On Mon, Jan 22, 2018 at 7:30 PM, Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:
> Not so dissimilar from your idea but you could do
>
> Begin SQL
>
> SELECT * FROM [myTable] LIMIT 0 into LISTBOX :m
quot;manually", see here, the last paragraph:
<http://forums.4d.com/Post/FR/19409974/1/19413742#19413742
<http://forums.4d.com/Post/FR/19409974/1/19413742#19413742>>
Briefly, after SQL into listbox, duplicate one column, do what you want with
that new column.
--
Arnaud d
a but you could do
>
> Begin SQL
>
> SELECT * FROM [myTable] LIMIT 0 into LISTBOX :myListbox;
>
> End SQL
**
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com
Not so dissimilar from your idea but you could do
Begin SQL
SELECT * FROM [myTable] LIMIT 0 into LISTBOX :myListbox;
End SQL
**
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists
While you are on the subject...
I am a big fan of:
$tSQL:="SELECT * FROM "+$tTableName+" INTO : "+$tLBox
Because it creates dynamic Listbox columns automatically.
Is there a clever way to select nothing into a Listbox so that an
empty listbox with all the columns defined? I could then fill the
_tech@lists.4d.com>
Subject: Re: 4D SQL Question
DELETE FROM users
WHERE id in [1,2.3];
would delete the three users with one of those ids (or none at all, if the ids
didn’t exist.)
DELETE FROM users
WHERE last_name=“Smith”;
would delete all users with t
ech
> <4d_tech@lists.4d.com> wrote:
>
> SQL newbie here...
>
> What is the correct syntax for deleting a number rows in a SQL database? Is
> it possible to use a 4D array which contains the values used by the WHERE
> clause?
>
> Or, do we have to delete each row indi
SQL newbie here...
What is the correct syntax for deleting a number rows in a SQL database? Is it
possible to use a 4D array which contains the values used by the WHERE clause?
Or, do we have to delete each row individually?
Thanks!
Steve
Hi ware you connecting to SQL server. Are you logging in or using windows
autghentication fiorm machine. I woiuld try the other and see if there is a
difference
Regards
Chuck
On Thu, Dec 21, 2017 at 3:04 PM, Stephen J. Orth via 4D_Tech <
4d_tech@lists.4d.com> wrote:
> Is there a known
Is there a known issue in V16 regarding the deletion of records from MS SQL
Server?
We converted a system from V15 R5 over to V16.3 NB217768. We are able to
read SQL records, but no longer able to delete them.
We are using the standard, built in 4D SQL commands, same code in both V15 &
[mailto:alantil...@gmail.com]
Sent: Wednesday, December 13, 2017 1:25 PM
To: Timothy Penner
Cc: 4D iNug Technical <4d_tech@lists.4d.com>
Subject: Re: Twin Process for 4D SQL Data Source
Hello Tim,
Thanks for the info. Where do I find pricing for ODBC Pro?
Alan
On Wed, Dec 13, 2017 at 4:20 PM, Timothy
Hello Tim,
Thanks for the info. Where do I find pricing for ODBC Pro?
Alan
On Wed, Dec 13, 2017 at 4:20 PM, Timothy Penner wrote:
> Hi Alan,
>
> > but I couldn't find a place where it is sold for 4d server.
>
> ODBC Pro can be purchased as an expansion when configuring a new server on
> the stor
Hi Alan,
> but I couldn't find a place where it is sold for 4d server.
ODBC Pro can be purchased as an expansion when configuring a new server on the
store:
https://store.4d.com/us/article/4USE16.shtml
https://store.4d.com/us/article/4USD16.shtml
ODBC Pro can also be purchased as an addon for a
it
is interesting that ODBC Pro offers cloning of 4D tables as ODBC tables and
vice versa. One of the things I do regularly is to load data from 4d and
theoretically the same data from the SQL Server system and compare it using
arrays to find records that have changed. If this could be done within on
t counted 14 logins to the SQL Server in 1 min
> 50 sec so I ran a test logging in and out 20 times and this took 2.03
> seconds.
> There would have to be some overhead associated with using a separate
> process so I doubt there would be any gain.
> It just seems rather clunky to have to
Hello Chuck,
You are probably right. I just counted 14 logins to the SQL Server in 1 min
50 sec so I ran a test logging in and out 20 times and this took 2.03
seconds.
There would have to be some overhead associated with using a separate
process so I doubt there would be any gain.
It just seems
ryone,
>
> I find myself switching data sources frequently (20 or more times in a few
> minutes-I'll count the number...) back and forth between 4D and my client's
> MS SQL Server based system. So today I've been contemplating the idea that
> I might put all my 4
Hello everyone,
I find myself switching data sources frequently (20 or more times in a few
minutes-I'll count the number...) back and forth between 4D and my client's
MS SQL Server based system. So today I've been contemplating the idea that
I might put all my 4D SQL code in a sepa
Hello,
there might be benefits in having a NorthWind / Pubs example in 4D,
but the Neo4j example seems to have more to do with importing CSV.
https://neo4j.com/developer/guide-importing-data-and-etl/
what you really need is a decent method that can export CSV from 4D (with
headers).
EXPORT DAT
Pat,
If I'm looking at it correctly this would allow me to access a running MySql
database from 4D.
What I was trying to do was create the Northwind db in a 4D database so I
could practice exporting the data neo4J is using in its demo. I thought it
would be useful for working out the code on the
4 PM, Kirk Brooks wrote:
>
> > Hi Folks,
> > I would like to setup the Northwind sample data set. I found this site:
> >
> > https://northwinddatabase.codeplex.com/
> >
> > but 4D fails when attempting to use SQL EXECUTE SCRIPT on it. I looked at
> > the Micr
up the Northwind sample data set. I found this site:
>
> https://northwinddatabase.codeplex.com/
>
> but 4D fails when attempting to use SQL EXECUTE SCRIPT on it. I looked at
> the Microsoft site but have no idea which flavor would/could work.
>
> So - anyone have a suggestion?
Hey Pat,
I'm using v16.3 on a Mac. I put the file in the folder with the database
and ran
SQL EXECUTE SCRIPT("northwind.sql";SQL On error confirm)
The error seems to happen right away:
Error when executing the method "__test" at line number 5
Generic parsing er
m>
wrote:
> That looks like a sql server sample database.
>
> https://docs.microsoft.com/en-us/dotnet/framework/data/
> adonet/sql/linq/downloading-sample-databases <https://docs.microsoft.com/
> en-us/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases>
&
lks,
> I would like to setup the Northwind sample data set. I found this site:
>
> https://northwinddatabase.codeplex.com/
>
> but 4D fails when attempting to use SQL EXECUTE SCRIPT on it. I looked at
> the Microsoft site but have no idea which flavor would/could work.
&
That looks like a sql server sample database.
https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases
<https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases>
why were you curious about it?
>
Hi Folks,
I would like to setup the Northwind sample data set. I found this site:
https://northwinddatabase.codeplex.com/
but 4D fails when attempting to use SQL EXECUTE SCRIPT on it. I looked at
the Microsoft site but have no idea which flavor would/could work.
So - anyone have a suggestion
is this client server and compiled?
it seems certain local variable names just don't work over the network.
I would try using the "execute on server" method property and let the code run
on server.
> 2017/11/10 8:21、Allan Udy via 4D_Tech <4d_tech@lists.4d.com> のメール:
&g
Hi All,
Currently using the following example code from the Knowledge Base to
determine the AutoIncrement status of a field:
C_LONGINT($1;$table_id_l)
C_LONGINT($2;$column_id_l)
C_BOOLEAN($0;$autoInc_b)
If (Count parameters>=2)
$table_id_l:=$1
$column_id_l:=$2
Begin
that explains the fact that a restart of 4D fixed the issue!
On Wed, 1 Nov 2017 16:10:46 -0500, Richard Wright via 4D_Tech wrote:
> I’ve seen Nested Begin/End SQL errors when a previous statement did
> not complete. If you get an error and then abort the code it’s left
> open and the
I’ve seen Nested Begin/End SQL errors when a previous statement did not
complete. If you get an error and then abort the code it’s left open and the
next time you try to run you get this kind of error.
Richard Wright
DataDomain
rwri
May I kindly suggest reading a basic primer on SQL.
> Date: Wed, 1 Nov 2017 17:15:01 +
> From: Timothy Penner
>
> I think you have multiple issues with this SQL Statement.
>
> I don’t think you can select a COUNT(*) along with other fields in the same
> SQL Stateme
you have multiple issues with this SQL Statement.
>
> I don’t think you can select a COUNT(*) along with other fields in the same
> SQL Statement;
> Count returns a number, not an array.
> While the fields return an array.
>
> In addition to that, what is 'HAVING Co
Tim
Aside from the missing colon - which had been corrected - I also believe
the statement is valid, since it's working in another method in the DB. To
eliminate copy and past errors, I retyped the SQL block, but still got the
error.
What I didn't do is quit and restart 4D - after tha
> I think you have multiple issues with this SQL Statement.
I was wrong. I didn’t fully understand the SQL statement at the time of my last
reply, upon further inspection it seems the SQL is valid (apart from the
missing : in the variable reference).
There must be something else wrong, l
I think you have multiple issues with this SQL Statement.
I don’t think you can select a COUNT(*) along with other fields in the same SQL
Statement;
Count returns a number, not an array.
While the fields return an array.
In addition to that, what is 'HAVING Count(*) > 1' suppose
17, at 17:04, David Witton via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> >
> > Here's a SQL block that throws Error code: 1427, Nested Begin/End SQL not
> > allowed.
> >
> > Begin SQL
> > SELECT Athena.First_Name, Athena.Last_Name, Athena.DOB, Count(
No “:” in front of $arrCount?
Milan
Sent from my iPad
> On Nov 1, 2017, at 17:04, David Witton via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> Here's a SQL block that throws Error code: 1427, Nested Begin/End SQL not
> allowed.
>
> Begin SQL
> SELECT
Here's a SQL block that throws Error code: 1427, Nested Begin/End SQL not
allowed.
Begin SQL
SELECT Athena.First_Name, Athena.Last_Name, Athena.DOB, Count(*) as recCount
from Athena
Group by Athena.First_Name,Athena.Last_Name,Athena.DOB
HAVING Count (*)>1
into :$arrFld1,:$arrFld2,:
Have you tried BEGIN SQL .. END SQL? You can use variables or arrays this way.
Kind regards,
Rudy Mortier
Two Way Communications bvba
> On 13 Oct 2017, at 19:33, STARDATA via 4D_Tech <4d_tech@lists.4d.com> wrote:
>
> The problem is that i have to put data into an associativ
The problem is that i have to put data into an associative array but sql
execute doesn't seem to work. I've created a "User DSN" and i can connect to
it trough the "External connection" window that appear if you leave the
first SQL LOGIN parameter empty. After t
You have two options that I know of.
1. ODBC
2. ADO plugin from Rob Laveaux/Pluggers
You will, of course, need to write some SQL code and dump any data results into
arrays.
Randy Engle, Director
XC2 Software LLC – XC2LIVE!
-Original Message-
From: 4D_Tech [mailto:4d_tech
Hi everyone,
I'm looking for a way to connect 4d to sql server and query it as if it is a
4D database. Can anyone help me?
--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
4D Internet Users Grou
101 - 200 of 321 matches
Mail list logo