• Getting error when selecting triggers to display in System I Navigator

    I keep getting an error when selecting triggers to display in navigator: sql0205 Eventdelete not in table systriggers in qsys2.

    Pgmr4660 pointsBadges:
  • Creating forms with PHP and MySQL

    Using PHP and MySQL, I am trying to create a table form which can input multiple data within the form. When the space row provided is not enough, I want to add in another function which can help add rows in the same table. How can I do this?

    MarkG7135 pointsBadges:
  • Download from the AS/400 tab delimited file

    I need to be able to download in an automated fashion, a DB2 table as a tab delimited text file on a PC. I have successfully done this manually using the Actions munu in client access but need to be able to do it automatically in either a CL of a PC scheduled job so that it will run unattended. Any...

    Butcheanes5 pointsBadges:
  • How do I save pictures in database VB.NET

    I'm using SQL Express to develop application which have I pictures so I can try how a save picture inside database and loading VB picture box. Can anyone tell me please? How do I do this?

    12345678900110 pointsBadges:
  • Is it possible to randomly select rows in a SQL Server database?

    I've been using SQL Server 2005 and in my database, I have a table labeled "customerNames" which has two different columns (ID and name). It has around 1,000 results. I've been trying to create a function that allows me the capability to select five different customers randomly every time. Would...

    ITKE352,425 pointsBadges:
  • Pulling a list of triggers in a SQL Server database

    I'm trying to get a list of triggers in a SQL Server database with the table name and the table's schema. Here's what I have so far: SELECT trigger_name = name, trigger_owner = USER_NAME(uid),table_schema = , table_name = OBJECT_NAME(parent_obj), isupdate = OBJECTPROPERTY( id,...

    ITKE352,425 pointsBadges:
  • How to create a database table from XSD files

    I have a bunch of XSD files (from which I get data access classes, stored procedures, among other things). But now I need to generate a database table from these and I don't know how. Anyone know of a tool than can generate DDL statements? I would appreciate some help.

    ITKE352,425 pointsBadges:
  • odbc as/400 connect to mysql

    I am trying to figure out how to get data from the as/400 into mysql

    Sunnyday25 pointsBadges:
  • Export flat file data as .txt

    I have data in a flat file that I want to send to an external server in text file format. How can I do this within a RPGLE or CL program?

    LarryL707830 pointsBadges:
  • Access Forms

    Can information appear on a form based on information on a table? I have information on a table that I want to appear on a form, but I want the info to change on the form based on a change made in the table. EG I have a person down on a rota as doing an overnight, the name will change each night,...

    quinny5 pointsBadges:
  • Indexes and abstracts in SQL Server

    In regards to a SQL Server, what is an index? Also, what is an abstract, and could you please explain the types of both of these items?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error 2282 in Microsoft Access

    Hello all, I have a database that sends a report by email in pdf format automatically by pressing a button. My problem is that whilst this works perfectly on my computer, I get an error "2282 - the format in which you are attempting to output the current object is not available." on other users...

    Pmallick5 pointsBadges:
  • Is it possible to replace a string in a SQL Server table?

    We have a SQL Server table which references different paths (UNC or otherwise) but we've just found out that the path is going to change. In our path column, we have many records and we need to change a portion of the path (not the entire thing). We also have to change the string to the new one as...

    ITKE352,425 pointsBadges:
  • auto send e-mail

    How does one auto send e-mail from access

    Mabaxter5 pointsBadges:
  • Storing GPS coordinates in a MySQL database

    We have a MySQL database that carries both longitude and latitude (GPS data). Here's how it's stored: column type ------------------------ geolat decimal(10,6) geolng decimal(10,6) Here's our question: Do we really need a data type that's large as "decimal(10.6)" to properly store the data?

    ITKE352,425 pointsBadges:
  • How to connect and query C# records to a database

    I have a set of records in C# and I need a way to connect and query them to a database. How can this be done? Thanks!

    ITKE352,425 pointsBadges:
  • How can I my MySQL database file working?

    I was recently given a MySQL database file and now I need to restore it as a database on Windows Server 2008. I've been trying to use MySQL Administrator but I keep getting this error: The selected file was generated by mysqldump and cannot be restored by this application. What should I do to get...

    ITKE352,425 pointsBadges:
  • Can we have multiple primary keys in a single table on a SQL Server database?

    For our database, is it possible for us to have multiple keys in a single table? We're using an SQL Server database.

    ITKE352,425 pointsBadges:
  • Visual Basic 2012 time format for label link to database

    I am new to programming and i was trying to figure out how to display a label i have as 12 hour format from the current 24 hour format. currently the label pulls the data from a Mysql database but display as 24 hour format since that's how Mysql stores it. all i want to do is have the label display...

    jafranklin775 pointsBadges:
  • Clustering in SQL Server 2005

    What's the steps to use (Clustering ) in any SQL Server 2005 System??

    ScorpionSQL10 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