Getting results from SQL statement to print into text area

  • (3 Pages)
  • +
  • 1
  • 2
  • 3

30 Replies - 2523 Views - Last Post: 14 March 2014 - 05:16 PM Rate Topic: -----

#1 jmsutton334   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 56
  • Joined: 25-October 10

Getting results from SQL statement to print into text area

Posted 14 March 2014 - 11:51 AM

Hello all, I have a question. I have written the code to get a specific row that matches the "ID" of the customer in which the user inputted. What I want this to do is for the user to enter the "ID" which is the primary key in my access table named "Table1". They will then press search and will open up text area where the results will be displayed. It will display "Fname", "Lname", "E-mail", "Sign-up date". Those are exactly how they are named in access database.

There are no syntax error, it compiles and runs just fine, but there is a logical error somewhere, because it is outputting nothing into my text area. Here is my code

Connection to my access db

import java.sql.*;
 
public class db
{
   //connections to db
   Connection con;
   
   //have access to table inside db
   Statement st;
   
   //have access to records inside db
   ResultSet rs;
   
   //have access to records inside db
   ResultSet rs2;
   
   //when you create object of any class, this will initialize it
   public db()
   {
      connect();
   }
   
   //method to develop connection to db
   public void connect()
   {
      try
      {
         //driver for access db
         String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
         
         //load class of the driver
         Class.forName(driver);
         
         //variable that is given our db name 'db1'
         String db = "jdbc:odbc:db1";
         
         //connecting to our db
         con = DriverManager.getConnection(db);
         
         //create statement to help us gain access to table in db
         st = con.createStatement(rs.TYPE_SCROLL_INSENSITIVE, rs.CONCUR_UPDATABLE);
         
         //statement that selects everything from our table
         String sql = "select * from Table1";
         
         //execute query, assigning all records in db to 'rs'
         rs = st.executeQuery(sql);                         
      }
      catch(Exception ex)
      {
      
      }
   }
 
   public static void main (String[] args)
   {
      //object of db class
      new db();
      
      //object of gui class
      new gui();
   }   
}




Here is my code for search and result frame, also the search button

//this is the 'retrieve customer' frame
   public void searchFrame()
   {
      //creates new frame with frame variable
      searchFrame = new JFrame("Retrieve Customer");
      
      //allows to see frame
      searchFrame.setVisible(false);
      
      //sets size of frame
      searchFrame.setSize(400,100);
      
      //frame will close when you hit close button
      searchFrame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
      
      //initializes labels and what they will display
      customerID = new JLabel("Customer ID");
      
      //initializes textfields and size
      customerIDTextBox = new JTextField(10);
      
      //creates new panel, hold all components and displays them on frame
      JPanel searchPanel = new JPanel();
      
      //sets panel background to light gray
      searchPanel.setBackground(Color.lightGray);
      
      //adds label 'fname' to panel      
      searchPanel.add(customerID);
      
      //sets textield background to light gray
      customerIDTextBox.setBackground(Color.lightGray);
      
      //add textfieled 'customerIDTextBox' to panel
      searchPanel.add(customerIDTextBox);
      
      //sets 'saveButton' background/foreground to light gray
      searchButton.setBackground(Color.lightGray);
      searchButton.setForeground(Color.darkGray);
      
     //sets 'saveButton' background/foreground to light gray
      backButton.setBackground(Color.lightGray);
      backButton.setForeground(Color.darkGray);
   
      //adds button to panel
      searchPanel.add(searchButton);
      searchPanel.add(backButton);
      
      //adds panel to frame   
      searchFrame.add(searchPanel);
   }
   
   //this is the text area that will hold 'retrieved customer', may or may not use this
   public void resultFrame()
   {  
      //creates new frame with frame variable
      resultFrame = new JFrame("Customer Results");
         
      //allows to see frame
      resultFrame.setVisible(false);
         
      //sets size of frame
      resultFrame.setSize(300,200);
         
      //frame will close when you hit close button
      resultFrame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
                  
      //creates text area and size
      textArea = new JTextArea(40, 30);
         
      //sets text area to not be edited
      textArea.setEditable(false);
         
      //sets background of 'textArea' to light gray
      textArea.setBackground(Color.lightGray);
         
      //creates new panel, hold all components and displays them on frame
      JPanel resultPanel = new JPanel();
         
      //sets panel background to light gray
      resultPanel.setBackground(Color.lightGray);
         
      //adds label 'fname' to panel      
      resultPanel.add(textArea);
         
      //adds panel to frame   
      resultFrame.add(resultPanel);   
   }
    
   //method for action listeners
   public void btnAction2()
   {
      searchButton.addActionListener(
            new ActionListener()
            {
               //method for events that will be performed when 'searchButton' is pressed
               public void actionPerformed(ActionEvent e)
               {    
                  try
                  {
                     //sets 'resultFrame' to visible
                     resultFrame.setVisible(true);
                     
                     //creates an instance of the 'CustomerTable'
                     //CustomerTable mainFrame	= new CustomerTable();
                     
                     //sets table to un-editable
                     //mainFrame.setEnabled(false);
                     
                     //sets 'mainFrame' to visible
                     //mainFrame.setVisible(true);
                                       
                     //sets 'searchFrame' to not visible
                     searchFrame.setVisible(false);
                  
                     //variable that contains data user enters in 'textBox4', use trim to remove any spaces
                     String customerID = customerIDTextBox.getText().trim();
                     
                     //statement that selects customer with matching 'customeID' from db
                     String sql2 = "SELECT Fname, Lname, E-mail, Sign-up date FROM Table1 WHERE ID = '" + customerID + "'";
                     
                     //execute query, assigning specified record in db to 'rs2'
                     rs2 = st.executeQuery(sql2);
                     
                     //sets text from specified row/fields into 'textArea'
                     textArea.setText(rs2.getString("Fname"));
                     textArea.setText(rs2.getString("Lname"));
                     textArea.setText(rs2.getString("E-mail"));
                     textArea.setText(rs2.getString("Sign-up date"));                  
                  }
                  
                  catch(Exception ex)
                  {
                  
                  }                
               }
                               
            });




Lines 126-129 is where I have the results printing out to my text area, but is not working.

Thanks for any help

Is This A Good Question/Topic? 0
  • +

Replies To: Getting results from SQL statement to print into text area

#2 andrewsw   User is online

  • RequestedRangeNotSatisfiable
  • member icon

Reputation: 6554
  • View blog
  • Posts: 26,569
  • Joined: 12-December 12

Re: Getting results from SQL statement to print into text area

Posted 14 March 2014 - 11:55 AM

"SELECT Fname, Lname, E-mail, Sign-up date FROM ...

Access (or any database for that matter) will not recognise Sign-up date as being a single field, particularly as Date is an Access reserved word. For Access, surround this field-name in square-brackets or, preferably, don't use spaces in field-names.

I would also surround E-mail in square brackets (well, I would remove the hyphen from the field-name) and.. don't name your table Table1 !!



And.. use prepared statements, avoid using * as it is better to specify just the fields you need, and, if your ID is a number, it doesn't need to be enclosed in apostrophes (prepared statements avoid this concern) although it probably works with them.

This post has been edited by andrewsw: 14 March 2014 - 11:59 AM

Was This Post Helpful? 0
  • +
  • -

#3 jmsutton334   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 56
  • Joined: 25-October 10

Re: Getting results from SQL statement to print into text area

Posted 14 March 2014 - 12:00 PM

But wouldn't it at least display "Fname" and "Lname"? Even if the other tow weren't inputted correctly.
Was This Post Helpful? 0
  • +
  • -

#4 jmsutton334   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 56
  • Joined: 25-October 10

Re: Getting results from SQL statement to print into text area

Posted 14 March 2014 - 12:05 PM

String sql2 = "SELECT Fname, Lname, [E-mail], [Sign-up date] FROM Table1 WHERE ID = '" + customerID + "'";                    


Is this correct now with brackets? And I am not sure as to how to do a prepared statement? Could you provide an example?

This post has been edited by andrewsw: 14 March 2014 - 12:08 PM
Reason for edit:: Removed quote

Was This Post Helpful? 0
  • +
  • -

#5 andrewsw   User is online

  • RequestedRangeNotSatisfiable
  • member icon

Reputation: 6554
  • View blog
  • Posts: 26,569
  • Joined: 12-December 12

Re: Getting results from SQL statement to print into text area

Posted 14 March 2014 - 12:13 PM

Using Prepared Statements :tutoracles

View Postjmsutton334, on 14 March 2014 - 07:00 PM, said:

But wouldn't it at least display "Fname" and "Lname"? Even if the other tow weren't inputted correctly.

It probably fails completely but because you are catching all errors (Exception) and doing nothing with them, you have no indication that there is a problem.
Was This Post Helpful? 1
  • +
  • -

#6 jmsutton334   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 56
  • Joined: 25-October 10

Re: Getting results from SQL statement to print into text area

Posted 14 March 2014 - 12:16 PM

How do you fix that?

This post has been edited by andrewsw: 14 March 2014 - 12:20 PM
Reason for edit:: There is no need to keep quoting the previous post

Was This Post Helpful? 0
  • +
  • -

#7 modi123_1   User is online

  • Suitor #2
  • member icon



Reputation: 14100
  • View blog
  • Posts: 56,520
  • Joined: 12-June 08

Re: Getting results from SQL statement to print into text area

Posted 14 March 2014 - 12:17 PM

Specifically - the catch part.. it has that variable 'ex'.. use it! print out the exception information! That is crucial for understanding what is wrong, and the first step in debugging the issue!

132	                  catch(Exception ex)
133	                  {
134	                   
135	                  } 

Was This Post Helpful? 0
  • +
  • -

#8 andrewsw   User is online

  • RequestedRangeNotSatisfiable
  • member icon

Reputation: 6554
  • View blog
  • Posts: 26,569
  • Joined: 12-December 12

Re: Getting results from SQL statement to print into text area

Posted 14 March 2014 - 12:19 PM

Remove the try..catch block entirely so that you can see all errors. If you are going to catch Exception you must do something with it, not ignore it. As a minimum you would print the stack-trace so that you can see the error messages.
Was This Post Helpful? 0
  • +
  • -

#9 jmsutton334   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 56
  • Joined: 25-October 10

Re: Getting results from SQL statement to print into text area

Posted 14 March 2014 - 12:49 PM

View Postmodi123_1, on 14 March 2014 - 12:17 PM, said:

Specifically - the catch part.. it has that variable 'ex'.. use it! print out the exception information! That is crucial for understanding what is wrong, and the first step in debugging the issue!

132	                  catch(Exception ex)
133	                  {
134	                   
135	                  } 



Here is what printed out when I printed my exceptions. I don't know how to interpret this?

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid cursor state
	at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6964)
	at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7121)
	at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3914)
	at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5697)
	at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:353)
	at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:410)
	at gui$8.actionPerformed(gui.java:843)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
	at java.awt.Component.processMouseEvent(Component.java:6505)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3320)
	at java.awt.Component.processEvent(Component.java:6270)
	at java.awt.Container.processEvent(Container.java:2229)
	at java.awt.Component.dispatchEventImpl(Component.java:4861)
	at java.awt.Container.dispatchEventImpl(Container.java:2287)
	at java.awt.Component.dispatchEvent(Component.java:4687)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
	at java.awt.Container.dispatchEventImpl(Container.java:2273)
	at java.awt.window.dispatchEventImpl(window.java:2719)
	at java.awt.Component.dispatchEvent(Component.java:4687)
	at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:735)
	at java.awt.EventQueue.access$200(EventQueue.java:103)
	at java.awt.EventQueue$3.run(EventQueue.java:694)
	at java.awt.EventQueue$3.run(EventQueue.java:692)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
	at java.awt.EventQueue$4.run(EventQueue.java:708)
	at java.awt.EventQueue$4.run(EventQueue.java:706)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:705)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)





View Postandrewsw, on 14 March 2014 - 12:19 PM, said:

Remove the try..catch block entirely so that you can see all errors. If you are going to catch Exception you must do something with it, not ignore it. As a minimum you would print the stack-trace so that you can see the error messages.


I get these errors when I remove my try catch block

gui.java:840: error: unreported exception SQLException; must be caught or declared to be thrown
                     rs2 = st.executeQuery(sql2);
                                          ^
gui.java:843: error: unreported exception SQLException; must be caught or declared to be thrown
                     textArea.setText(rs2.getString("Fname"));
                                                   ^
gui.java:844: error: unreported exception SQLException; must be caught or declared to be thrown
                     textArea.setText(rs2.getString("Lname"));
                                                   ^
gui.java:845: error: unreported exception SQLException; must be caught or declared to be thrown
                     textArea.setText(rs2.getString("E-mail"));
                                                   ^
gui.java:846: error: unreported exception SQLException; must be caught or declared to be thrown
                     textArea.setText(rs2.getString("Sign-up date"));                  
                                                   ^
5 errors



Was This Post Helpful? 0
  • +
  • -

#10 andrewsw   User is online

  • RequestedRangeNotSatisfiable
  • member icon

Reputation: 6554
  • View blog
  • Posts: 26,569
  • Joined: 12-December 12

Re: Getting results from SQL statement to print into text area

Posted 14 March 2014 - 01:15 PM

If you still have the try..catch within your connect() method then you'll need to remove that as well. It seems likely to me that you are not connecting successfully, but by ignoring ANY Exception you aren't receiving any information that would confirm this.

In the second code you need to catch the specific exception of SQLException, so you need:
try {
    // your database code here..
} catch (SQLException ex) {
    ex.printStackTrace();
}

This is what those second set of errors are saying, you need to catch this specific exception. Alternatively, you can add throws SQLException to your gui class.

Please note that Java class-names must/should start with a capital letter.

This post has been edited by andrewsw: 14 March 2014 - 01:16 PM

Was This Post Helpful? 0
  • +
  • -

#11 jmsutton334   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 56
  • Joined: 25-October 10

Re: Getting results from SQL statement to print into text area

Posted 14 March 2014 - 01:30 PM

I put the SQLException and got this as my output:

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid cursor state
	at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6964)
	at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7121)
	at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3914)
	at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5697)
	at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:353)
	at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:410)
	at gui$8.actionPerformed(gui.java:857)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
	at java.awt.Component.processMouseEvent(Component.java:6505)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3320)
	at java.awt.Component.processEvent(Component.java:6270)
	at java.awt.Container.processEvent(Container.java:2229)
	at java.awt.Component.dispatchEventImpl(Component.java:4861)
	at java.awt.Container.dispatchEventImpl(Container.java:2287)
	at java.awt.Component.dispatchEvent(Component.java:4687)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
	at java.awt.Container.dispatchEventImpl(Container.java:2273)
	at java.awt.window.dispatchEventImpl(window.java:2719)
	at java.awt.Component.dispatchEvent(Component.java:4687)
	at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:735)
	at java.awt.EventQueue.access$200(EventQueue.java:103)
	at java.awt.EventQueue$3.run(EventQueue.java:694)
	at java.awt.EventQueue$3.run(EventQueue.java:692)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
	at java.awt.EventQueue$4.run(EventQueue.java:708)
	at java.awt.EventQueue$4.run(EventQueue.java:706)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:705)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)



This is where I put it


 public void btnAction2()
   {
      searchButton.addActionListener(
            new ActionListener()
            {
               //method for events that will be performed when 'searchButton' is pressed
               public void actionPerformed(ActionEvent e)
               {    
                  try
                  {
                     //sets 'resultFrame' to visible
                     resultFrame.setVisible(true);
                     
                     //creates an instance of the 'CustomerTable'
                     //CustomerTable mainFrame	= new CustomerTable();
                     
                     //sets table to un-editable
                     //mainFrame.setEnabled(false);
                     
                     //sets 'mainFrame' to visible
                     //mainFrame.setVisible(true);
                                       
                     //sets 'searchFrame' to not visible
                     searchFrame.setVisible(false);
                  
                     //variable that contains data user enters in 'textBox4', use trim to remove any spaces
                     String customerID = customerIDTextBox.getText().trim();
                     
                     //statement that selects customer with matching 'customeID' from db
                     String sql2 = "SELECT Fname, Lname, [E-mail], [Sign-up date] FROM Table1 WHERE ID = " + customerID;
                     
                     //execute query, assigning specified record in db to 'rs2'
                     rs2 = st.executeQuery(sql2);
                     
                     //sets text from specified row/fields into 'textArea'
                     textArea.setText(rs2.getString("Fname"));
                     textArea.setText(rs2.getString("Lname"));
                     textArea.setText(rs2.getString("E-mail"));
                     textArea.setText(rs2.getString("Sign-up date"));                  
                  }
                  
                  catch(SQLException ex)
                  {
                         ex.printStackTrace(System.out);
                  }                
               }
                               
            });




Also, when I take out the try/catch block in connect() and gui(), I get the 5 errors I posted earlier.....

This post has been edited by andrewsw: 14 March 2014 - 02:27 PM
Reason for edit:: Removed previous quote

Was This Post Helpful? 0
  • +
  • -

#12 x68zeppelin80x   User is offline

  • D.I.C Addict

Reputation: 130
  • View blog
  • Posts: 576
  • Joined: 07-March 09

Re: Getting results from SQL statement to print into text area

Posted 14 March 2014 - 02:30 PM

Just going to point this out:

jmsutton334 said:

"Fname", "Lname", "E-mail", "Sign-up date"


MySQL, if you are going to use it (I know you are using Microsoft Access), does not like hyphens (-). Use underscores(_) instead. This makes your tables portable.

I would try the following:

create table USER (
    ID           bigint not null auto_increment,
    FNAME        varchar(64),
    LNAME        varchar(64),
    EMAIL        varchar(128),
    SIGNUP_DATE  date
);

This post has been edited by x68zeppelin80x: 14 March 2014 - 02:35 PM

Was This Post Helpful? 0
  • +
  • -

#13 jmsutton334   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 56
  • Joined: 25-October 10

Re: Getting results from SQL statement to print into text area

Posted 14 March 2014 - 02:36 PM

I am not using MYSQL, I am using Microsoft Access...

This post has been edited by andrewsw: 14 March 2014 - 02:39 PM
Reason for edit:: There is no need to keep quoting the previous post

Was This Post Helpful? 0
  • +
  • -

#14 andrewsw   User is online

  • RequestedRangeNotSatisfiable
  • member icon

Reputation: 6554
  • View blog
  • Posts: 26,569
  • Joined: 12-December 12

Re: Getting results from SQL statement to print into text area

Posted 14 March 2014 - 02:38 PM

A little research suggests:

Quote

When you do st.executeQuery(), the initial position of the ResultSet is BEFORE the first row.

You have to do rs2.next() to advance it to the first row.

Enclose your ResultSet processing in a if ( rs2.next() ) {} block

Otherwise, perhaps there is a problem with the connection itself. Good luck.
Was This Post Helpful? 0
  • +
  • -

#15 x68zeppelin80x   User is offline

  • D.I.C Addict

Reputation: 130
  • View blog
  • Posts: 576
  • Joined: 07-March 09

Re: Getting results from SQL statement to print into text area

Posted 14 March 2014 - 02:39 PM

View Postjmsutton334, on 14 March 2014 - 05:36 PM, said:

View Postx68zeppelin80x, on 14 March 2014 - 02:30 PM, said:

(I know you are using Microsoft Access)


I am not using MYSQL, I am using Microsoft Access...


As I said.

I am recommending a standard DB practice involving the use of illegal characters.
Was This Post Helpful? 0
  • +
  • -

  • (3 Pages)
  • +
  • 1
  • 2
  • 3