• Paragraph marks in an ASP blog page.

    My web site includes an asp created blog page that accepts a message in a form text box, sends it to an Access database then returns it to the page. It works without trouble EXCEPT when a user hits enter to go to a new paragraph. The paragraph character is sent to the database but ignored when...

    Boblafferty20 pointsBadges:
  • Execute command in SQL

    can someone tell me the error in this statement declare @cmd nvarchar(4000) declare @PatNo bigint set @PatNo=123 set @cmd= N'insert into TmpDues ( PatNo, BillDate, ReceiptNo, PayMode Amt) select ReceiptTable.PatNo,ReceiptTable.BillDate,ReceiptTable.ReceiptNO,'+ '''Cash'''+' as PayMode,CashAmount...

    Ash1235 pointsBadges:
  • SQL Studio Express scheduled backup

    I need a scheduled backup for a standalone SQL database on an XP Pro PC. I have Studio Express installed and this does not have a scheduling utility. Can anyone suggest a way of achieving this without the expense of an SQL Express license

    James015 pointsBadges:
  • Flat file to PF conversion

    Hi, can anybody tell me how to transfer the entire flat files contents to a new Physical file in regular fields format?

    ten20081,150 pointsBadges:
  • How to get delete history from schema

    How to get delete history from a schema? Application requirement is to get the username ,primary key,date for the deleted records from tables.

    Sureshborse5 pointsBadges:
  • Free Chapter – Tuning database applications for performance

    Another free chapter download is available on the IT Bookworm Blog. Written by: John Goodson and Robert A. Steward Book: The Data Access Handbook: Achieving optimal database application performance and scalability Overview: “Performance and scalability are more critical than ever in today’s...

    BrentSheets6,875 pointsBadges:
  • How to use DateDiff to calculate costs?

    Hi, In my Access bookings system you select a number of Units and a start and end booking time. I need to calculate the cost of each Unit for the booking as well as a total cost for all Units in the booking. The information is stored in two tables: a bookings table called tblHourPeriod with the...

    Dontgetit105 pointsBadges:
  • Open Access 2007 files with Windows 2000 OS

    Is there a reader that that will read .accdb files using a Windows 2000 operating system?

    Skywatcher10 pointsBadges:
  • Calculating prior Query fields

    Inside my query, is four listed fields; date, printer, and a Start and End meter for daily meter readings to keep track of printer impressions. I'm trying to receive a return value by subtracting a meter reading from the START field in a current row and the END meter in the previous row depending...

    Bostic8720 pointsBadges:
  • Access: Form to input dates

    Hi, I was wondering if some Access expert could help me with this short questions. I have an access database with one table, which has 4 columns: ID, Task, Date, Hours I would like to create a form in which a user sees the following headings Task : Mon : Tue : Wed : Thur : Fri and they just fill in...

    Js876525 pointsBadges:
  • DateAdd Function

    I have a dateadd function in a query Cdate:DateAdd("yyyy",[Length],[StartDate]). I need the year added from how long we give someone to complete certain courses. Example, Lenght = 2, StartDate = 1/2/2007, Cdate = 1/2/2009. This works and that's not the problem. Now I need to run the query with the...

    AccessFlunky50 pointsBadges:
  • DB2/400 – Source Physical File Deletion?

    I have a question related to DB2/400. Let’s say, your source physical file name is “QDDSSRC” and inside this source physical file when you try to create a physical file with name same as that of source physical file “QDDSSRC”, if I am not wrong the source physical file will get deleted....

    BibinGeorge130 pointsBadges:
  • Clustered and Non clustered composite index

    I have a database that has a clustered composite index and 2 non clustered indexes on each of the columns used in the composite index. Doesn't it just need the clustered index?

    Bleeb45 pointsBadges:
  • Call SQR (Structured Query Reporter)

    how to call sqr on aix and return spf to windows

    Gdcl5 pointsBadges:
  • Label Traxxx Client – Anyone heard of this program?

    Label Traxxx Client - Anyone heard of this program? We use this every day as one of our main databases. Does anyone know of a manual of shortcuts or how to understand this program?

    Jreifenstein001185 pointsBadges:
  • Querying database tables with their descriptions

    I want to query an SQL server database for specific tables and their descriptions. How do I do that? Is there a special tool needed to do this?

    Sheni5 pointsBadges:
  • empty fields in a query

    I have a column with answers that people responded to different questions about themseleves. I have another column with the question id that the answer corresponds to. i want to display the answers in separate columns based on which question it corresponds to. Each column should be filled with the...

    Bananahead60 pointsBadges:
  • Update a flat file through CL

    Hi, I have copied a message from MSGQ into a CL variable. Is it possible to write that message in a flat fiile through CL.

    Cool400115 pointsBadges:
  • QYKMIMPK Usage

    Sorry if this shows up more than once, first time poster and I'm a tad confused about how to get my question to appear under a specific category. I'm trying to use the iSeries QYKMIMPK api to import a certificate into the *SYSTEM certificate store and encountering error CFPB006, which appears to be...

    Toadfoot10 pointsBadges:
  • DB2 logical files

    HI, i wanted to know if i can add a new field to a PF via a logical file. If yes give me an example. thanks....ram

    ten20081,150 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