Skip navigation
Currently Being Moderated

Using Data/Services with SQL Database

Mar 7, 2012 7:38 AM

Tags: #data #database #sql #data/services #mamp

Hi,

 

Can anyon give me some assistance in using Flash Builders Data/Services feature? Basically i have my own database setup locally using MAMP and i want to be able to read/write to this database in Flash Builder.

 

I can succesflly read from the database by adding a datagrid and applying the 'getAllClients(item:Clients):int' from the Data/Services onto the datagrid. This list all of my database results.

 

However when i try to write to the database it does not work by right clicking 'createClients(item:Clients):int' under Data/Services > Generate Form, this then gives me severaltext input boxes for every field in my database table 'clients'. When i run this application, enter data into the text input boxes (id,name,surname,address,email), click 'Submit' nothing happens?

 

What DOES work is when i right click on 'createClients(item:Clients):int' under Data/Services > Test Operation > Enter appropriate data under 'Enter Value' > click 'Test' and my database is updated successfully!

 

So basically i cannot write to my database through source code but i can using the 'Test Operation' feature? Why could this be?

 

Thanks very much for any help

 

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points