Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by biosraman

  1. biosraman

    HEY CAN U HELP ME COMM..

    Hi, It is very well possible using Visual Basic. I have been doing it for the past 2 years. You can use MSCOMM control to communicate via Serial port & you have to use some API for Parallel port. Raman
  2. biosraman

    Convert string field to date via sql

    Dear gabeshackle, I am not sure of the database you are using, but most of the database has function to convert one datatype to another. like to_date() in oracle, format() in Access. If the information are not sufficient please feel free to mail me at simp_raman@rediffmail.com , meanwhile...
  3. biosraman

    SCO Unix SQL Database... Accessing Remotely?

    Hi Mr.Jonathan, I am not clear of the requirements. Most of the SQLs comes with client for all OS. You can view using any ODBC test tool. To do that create a DSN for your database and call that in the test tool. If you need further detail, please feel free to post for more questions.
  4. biosraman

    Specifying carriage return/line feed in an SQL statement

    Dear SpaceRain, I have worked in simial problem. Change your column type to VarChar and instead of single quote (') in insert into statement use double quotes. I have attached a example for your convience. INSERT INTO mytab (ID, VAL) VALUES (" & CHR(34) & idstr & CHR(34) & "," &...
  5. biosraman

    selecting 1 instance of duplicate records

    Dear WakeUpDeadMan, The DISTINCT caluse will solve your problem. That is SELECT DISTINCT FIELD1 FROM <tablename> In case of detailed explanation please feel free to mail me at simp_raman@rediffmail.com
  6. biosraman

    Eliminate records duplication other than using DISTINCT and GROUP BY

    hi, I am not able to understand the question. Please send me the details. I need the table structure and constraints information. my mail id is biosraman@yahoo.com
  7. biosraman

    Select Statement Search Help

    hi, it is very simple use the following in your where clause WHERE <field> LIKE &amp; &quot;&quot;&quot; &amp; &quot;*&quot; &amp; gWordClientSearch &amp; &quot;*&quot; &amp; &quot;&quot;&quot;; incase of Access table use as it is. in case of Oralce database use % instead of *. the menaing is...
  8. biosraman

    Changing mindsets

    generaly people hear things from people, who they believe not form the experts. because to explain the problem they are in need of the person whom they can realy on. if that person is not constructive, it happends as you said. bacause the biosed mind is not in a position to analyze the situation...
  9. biosraman

    Re-formatted HDD, now can no longer install office 97..

    hi Dave, It is very simple, when you install Ms Office, select custom installation. Where remove the check bok &quot;Database connectivity&quot; or &quot;ODBC connectivity&quot;. It seems the problem is with your Ms Office setup disk or CDROM not with the harddisk. If you need the ODBC...
  10. biosraman

    hardware interfacing through C

    Hi, You can create interface to the computer in various ways. the easy way is to communicate via com port. i am not sure about your requirement. you have to select the interface type based on various parameters.
  11. biosraman

    Windows and Linux

    hi, the best way is partition your disk as how much you need for your windows OS & install windows, leave the remaining unportitioned. install Linux. it will use the unportitioned space for linux installation. The important issues are You can have a maximum of 4 primary partitions. so have...

Part and Inventory Search