• Date problem with Delphi 7

    I am trying to select records where the date is smaller that a specific date by using Delphi 7. The data is stored in a MS access 2000 database. dtsdate.DataSet := qrydate ;  qrydate.Active := false ;  qrydate.SQL.Text := ' select * from datum where datum < 1994/02/05' ; qrydate.Active :=...

    Marieps5 pointsBadges:
  • What is the location of servlets?

    I have not been successful in executing a servlet whose physical location is C:MyWorkMyProjectclassesmyServlet.class. In the jsp file I have <form action="../classes.myServlet" method="post">. But, when I run the project within JDeveloper and when tried to execute the servlet, I get "The Page...

    Okemos0 pointsBadges:
  • Database connection problem

    I am working on a japanese project. the DB is oracle8i. So I am using classes102 and nls_charset10 driver zip files. I am able to connect to db through SQL* but not through code. the error is: java.sql.SQLException: 20 at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:407) at...

    Sankya1235 pointsBadges:
  • SQL table missing values

    Dear all, I have a table that typically has the following collumns: partnumber Company Division Responsible Records usually look like: partnumber company division responsible A 1 14 AAA A 1 13 BBB A 1 CCC B 1 14 AAA B 1 12 BBB B 1 DDD Now I need to create a query, that returns the following: A 1 14...

    Broeren79100 pointsBadges:
  • SQL auto increment by group with INSERT..

    Is it possible to define an auto-incremental coloumn which increments by 'group' ? I want to create a version log for an old table (uniquely keyed 'HOWTONO') which contains records with 'How to' data in the form of short code-fields and some long fields with text.  I intend to trigger updates,...

    DanTheDane2,555 pointsBadges:
  • UPDATE a year from an ISO date field using SQL

    Dear Sir/Madam, How can I update the year from a date field. For example the date file contains '2008-12-31' and I would like to use I-Series navigator's SQL to update the date field above with '2007-11-31'.But my intention for the update here is to decrease/deduct the year by 1 year and the month...

    Khngkenny5 pointsBadges:
  • Bulk-Logged Recovery Model SQL Server 2005

    If I change the recovery model on the database from full to bulk-logged to run DBCC CheckDB and Rebuild Indexes is changing the recovery model the correct thing to do?

    Rick Martinez585 pointsBadges:
  • AS/400 SQL BLOBS

    I am trying to read data from a SQL table that contains a BLOB of 10MB.  Since the RPG field size is limited to 32KB, is this even possible?

    Newsqluser25 pointsBadges:
  • SQL cursor question

    hi, i've SQLRPGLe program in which i'm writing a cursor to select all records, order them by a field A (suppose employee number). And once all the rows fetched for an employee and printed, print the count at the bottom. Repeat this for all the subsequent employees.... i'm not sure how to...

    Nutangujar895 pointsBadges:
  • Using MS Acess SQL Passthrough To AS400 to find wholes in number sequence between to files

    Below is a SQL statement from an Ms-access pass-through query that is pulling the info from an AS400 system. The Fields marked in bold are the two table that I need help with. This query returns the same part numbers form each of the two columns of cores because there are of differ tables. I know...

    CompEng1,185 pointsBadges:
  • Reformatting SQL Data in a Field

    Hi, I'm new to the whole SQL experience and need help converting some data.  In our Activity table, data was imported into the UF_4 field incorrectly.  We want to convert this data "from a Decimal format" to a “NonDecimal”.  Currently the data looks like 5234.000 and we want it to look like...

    DCDJ45 pointsBadges:
  • Export tabels from SQL Server to iSeries

    I have a need to export a table on an SQL server to a file on the iSeries. I would also like this to be automated so that when the table is populated, the information is automatically exported to the file on the iSeries. I have tried using DTS/Enterprise Manager, but to no avail. Any help would be...

    As400coder5 pointsBadges:
  • Changing Table with RUNSQLSTM

    I have a table that I need to increase in size. It was created using QDDLSRC and the RUNSQLSTM command. This table has a DDM file connected to it. Is the a CHANGE TABLE or REPLACE TABLE statement that I could replace the CREATE TABLE statement with so I can rerun the RUNSQLSTM and leave the DDM...

    Las Vegas Lopez5 pointsBadges:
  • USROPN file in SQLRPGLE

    I have a SQLRPGLe program. Certain files are not available at client terminal depending upon the applications purchased by client. I have a common program called from all applications and hence i user open the files based on the application types. my confusion is if i refer a file directly in SQL...

    Nutangujar895 pointsBadges:
  • AS400 File to MS Access by SQL Passthrough Query

    I am trying to joint more then one File (table) from the AS400 by using MS-Access passthrough query SQL. I have been able to create separate individual queries. Like I mentioned before. I have using the below statement: (Query One) SELECT INPFP100.PFPFAM,INPFP100.PFPLIN,INPFP100.PFDES FROM...

    CompEng1,185 pointsBadges:
  • Display Bug with CFTextArea?

    Is there a bug or a trick needed for cftextarea to display DB retrieved query data? When I try to display a single retrieved MS-SQL varchar value in a cfwindow dynamically created form, I must refresh to see the value. A HTML textarea control on the same form displays properly. Multiple query rows...

    PKS15 pointsBadges:
  • AS/400 SQL

    want to all some users to run an SQL for display only and not allow update of delete. is there a way to do this

    Cficik10 pointsBadges:
  • Crystal 8 & SQL problem

    I created 80+ reports for the company intranet and they worked great. At the time the ODBC's were set up for a general SQL connection of sa/blank password. Now the connection connects via windows login/password. The reports have stopped working. I rebuilt one from scratch and put in on the intranet...

    Virtualfrankdotcom20 pointsBadges:
  • Finding differences between 2 files using sql

    I am on V5R2 and am trying to find differences between a production file and an archived file using the following sql stmt: SELECT MAX(Filename), PORD, PLINE FROM (SELECT 'HPO' as Filename, PORD,PLINE from HPOL01 UNION ALL SELECT 'ARC' as Filename, PORD,PLINE from HPOARC) group by PORD, PLINE...

    Peeveeh45 pointsBadges:
  • SQL upload images problem

    hello glad to be here, i have a upload images tutoiral that i got from here http://geekswithblogs.net/dotNETvinz...n-asp.net.aspx but i can not get it to work, it is slightly tweaked for me. errors i am getting are: ------ Build started: Project: C:\WebSite4\, Configuration: Debug Any CPU ------...

    Zpupster65 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following