×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
It appears to be that the external program CONVERTTOIDATE hasn't been registered as a function or stored procedure within the database so SQL can use it.
This is normally done with a CREATE FUNCTION or CREATE PROCEDURE command being run in SQL.
Is it possible an installation step for iDate was missed?
I'm not familiar with that product, but we have internal programs here that do these CREATE commands as embedded SQL so that external programs can be used within SQL or via ODBC.
Scott
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeff Young
Sent: Wednesday, May 30, 2012 12:06 PM
To: Midrange Systems Technical Discussion
Subject: Re: Help with iDate
Alan,
I was using the date format *MDCCYY, but the error I received was that CONVERTTOIDATE was not found. See my original message for the details.
Thanks,
________________________________
Scott Schollenberger
Vice President, Research & Development
P: 610-239-9988 x305
F: 610-239-9995
E: SSchollenberger@xxxxxxxxxxxxxxxxxx
[
http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]
[
http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]<
http://www.harriscomputer.com/>
100-2011 Renaissance Blvd.
King of Prussia, PA
19406
www.harris-schoolsolutions.com<
http://www.harris-schoolsolutions.com>
This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message.
midrange.com
