I really don't know where to post this, as it involves both SQLite
and Flex 3, but, I'll try here first. Here's what I have in
FlexBuilder:
sqlText = SELECT Up18RODetail.ProductID, TOTAL(Up18RODetail.Qty) AS
:qtySum +
FROM Up18RODetail LEFT JOIN
Of course, it was revealed to me a short while ago that you can't
parameterize a column alias that was the whole problem. Thanks.
--- In flexcoders@yahoogroups.com, Tom Chiverton [EMAIL PROTECTED]
wrote:
On Monday 11 Aug 2008, bredwards358 wrote:
sqlText = SELECT Up18RODetail.ProductID, TOTAL
While checking to make sure my summary information was correct, I got
this warning while debugging the application:
warning: unable to bind to property 'total2' on class
'mx.collections::SummaryObject' (class is not an IEventDispatcher)
warning: unable to bind to property 'total3' on class
While building report generation for our application, I noticed that
while trying to properly display summary information, I can only seem
to get one of the desired summary fields to display, here's the code
I'm using:
//Sets the grouping and summary stuff
rptGrpSr = new SummaryRow();
Problem solved, I simply used multiple render providers in the summary
row to display the data. Though if a better way exists I wouldn't mind
hearing it.
--- In flexcoders@yahoogroups.com, bredwards358 [EMAIL PROTECTED]
wrote:
While building report generation for our application, I noticed
]
wrote:
On Monday 28 Jul 2008, bredwards358 wrote:
Right now I'm trying to figure out how to implement Barcode generation
in my AIR app since two of the reports I need this to be able to print
require a list of Barcodes
You could just use a suitable barcode font. There's a free 6of9
So, today I found a type128 barcode font which fits the purposes of
the application we're developing quite nicely. However I've hit a bit
of a snag. When the font family of a dataGrid column is set, it sets
both the font of the column's items as well as the column header. This
would be fine if the
[mailto:[EMAIL PROTECTED] On
Behalf Of bredwards358
Sent: Tuesday, July 29, 2008 11:07 AM
To: flexcoders@yahoogroups.com
Subject: [flexcoders] Setting the dataGrid column's font and leaving the
header alone?
So, today I found a type128 barcode font which fits the purposes of
the application
Recently I got this barcode generation component from this place:
http://www.adobe.com/cfusion/exchange/index.cfm?event=extensionDetailloc=en_usextid=1179012
Right now I'm trying to figure out how to implement Barcode generation
in my AIR app since two of the reports I need this to be able to
So far so good in the application currently in development, I feel
like I'm in the home stretch. However something has come up which
could prove to be a roadblock in the near future. There are some
values which need to be totaled up and some of those need decimals.
Now I realize that the int
Bingo, thanks that I believe was exactly what I needed, it would seem
that when I'm making the database tables, it would be best to use REAL
and/or NUMBER as opposed to NUMERIC and/or INTEGER to best utilize
numbers with decimal points.
Brian Ross Edwards
Tech-Connect LLC
--- In
Sounds like a simple question and easily answered by a search, but
considering my own search-fu and not really finding anything
specifically relating to my question after my search I decided just to
post this.
In the app I'm working on, the user can print out reports by selecting
two dates and
in the remote database.
- Original Message
From: bredwards358 [EMAIL PROTECTED]
To: flexcoders@yahoogroups.com
Sent: Tuesday, July 15, 2008 8:35:36 AM
Subject: [flexcoders] Finding a date between dates
Sounds like a simple question and easily answered by a search, but
considering my
--- In flexcoders@yahoogroups.com, Alex Harui [EMAIL PROTECTED] wrote:
Try validateNow() at some point. Printing runs before validation so
sometimes you have to force validation
Ok, update time, I discovered that my dynamic dataGrid generation was
I have a problem which is proving very difficult to place, I am
implementing logic to dynamically generate an advanced datagrid and
set it as the source to a printAdvancedDataGrid in a component which
is the print view of whatever report that needs to be printed. Problem
is, while it looks like
So far in my odyssey to build the printing functionality for the AIR
app I'm building, I've run into a dilemma. I have a print view
component which holds the meat of what needs to be printed plus the
header and footer which is made visible and invisible depending on
what page is being printed. The
Thankfully, the basic printing functionality of Flex was all I needed
to print out the very basic looking reports I need for my application.
However, another requirement is adding Print Preview functionality. So
far in my experimentation I've managed to display what should be on
the report by
PROTECTED]
wrote:
On Monday 07 Jul 2008, bredwards358 wrote:
Now, I am aware of the marvelous looking FlexReport at
http://www.kemelyon.com/bts/, however I am at a loss as how to
install it so to speak (Meaning I have no idea what files and
components I need to copy over in order to use
I am well aware of the limitations with printing reports in Flex,
however considering how far along we are in our project, there's no
turning back now and I'm currently researching the best way to
implement report printing in the application. Since this is an AIR
app, it all needs to be client
Fair enough, as I said our reporting needs are very simple, just a
header and the required data, after downloading AlivePDF and looking at
it for a bit I can tell this is the front runner. FlexReport's lack of
an install guide and not having as much documentation marked it down in
my eyes but I
There is also FlexReport which also looks just as promising
http://www.kemelyon.com/bts/
--- In flexcoders@yahoogroups.com, Rick Winscot [EMAIL PROTECTED]
wrote:
Oh! Oh!
http://www.alivepdf.org/
Rick Winscot
From: flexcoders@yahoogroups.com [mailto:[EMAIL
Okay, problem solved, mismatched with the wrong sql statement and
parameters.
I am nearly done implementing database interactivity with the piece of
the application I'm working on. One problem remains before the minor
stuff which will wait until after all crucial functionality is finished.
What's supposed to happen and what actually does happen except for the
issue is that
In the application I'm currently developing, end users need to log in
to utilize it. Also I need to keep track of who is logged in so that I
can input that into a local database after certain actions. I've tried
using a public variable in a commonly used class, however since an
instance of that
After fixing an issue regarding where best to put an insert function
call in my drag and drop function I now have another issue. It seems
that it is simply not seeing the most recently dropped item. For
instance, when I drop the very first item, it throws an error saying
that 0 (The index of the
I've had a thought, would it be possible to add an event listener to
well, something that would fire the insert function on dragComplete?
If not then perhaps would it be best to call a function which compares
the data to already existing data either in the database through
select statements or
Okay, I believe my problem is solved, I never did think that after I got
my first programming job that I would have moments where I felt like a
complete and utter moron sometimes. While experimenting with where to
put the placeholder trace statements which stand in for the actual
function calls to
--- In flexcoders@yahoogroups.com, Alex Harui [EMAIL PROTECTED] wrote:
Why not just set a flag instead of calling preventDefault, then check
the flag afterwards.
BTW, you shouldn't be dispatching COLLECTION_CHANGE yourself. Best to
use itemUpdated when changing quantity. A
I do want the dragged items inserted into the DP, I just want to add a
function call to the end of that which inserts the new row into a
local database table. My problem is that the for-loop which checks for
duplicate entries and merely prevents the default event and updates a
value in the DP
Ok, one thing I'm going to try today is this; essentially I'm going to
say, forget that for-loop, just let it update the dataProvider. What
I'm going to do is write another function that runs each row of the dp
through a filterFunction and checks to see if it is there or not, if
it is there, then
Shortly after posting an update to my current predicament in this
topic thread:
http://tech.groups.yahoo.com/group/flexcoders/message/116030
and staring at the current logic in my dragDrop event(Shown in above
mentioned topic), I realized something. I don't need to do anything
else other than
I'm not sure I get what you're saying but it seems that if I want to
alter the default behavior to insert the new row to the database as
well as the target dataProvider as it normally does I would probably
need a custom DragManager to add that bit. Perhaps I could be phrasing
my question wrong,
In the part of my application that I'm currently working on I'm trying
to dynamically update a local database every time a change is made to
the dataProvider(ArrayCollection) when a dragDrop action is done. Here's
my code so far:
---
private function
.
I've tried using an else and else if block to enclose the insert
placeholder but it is still doing the same thing. Again, any advice
and help would be greatly appreciated.
--- In flexcoders@yahoogroups.com, bredwards358 [EMAIL PROTECTED]
wrote:
In the part of my application that I'm currently
In the application I am working on, the user can drag and drop items
from one datagrid to another. Now regardless of how the user exits the
window, the data is always saved. My question is basically, what would
be the best strategy for saving these changes. The dataProviders for
both grids are
Okay, that's a lot of code to take in but thanks that should be very
helpful. So far my ideas have been revolving around my second
strategy, which I am considering using a modified version of this code
for the drag and drop stuff. I only need to figure out the right
places to put the functions I
It is unfourtunately, even if it is being set to 0 it keeps
incrementing itself along with the growing dataProvider of the
dropTarget, I think I may have done something wrong to where it is not
seeing the identical values of the duplicate entry and is simply going
forward.
--- In
I believe I fixed my problem, I think the reason it wasn't seeing the
identical value in the array representing the dragged item was because
it did not know it's index so I changed this:
---
private function dragToOrders(event:DragEvent):void
{
try
{
var
I finished a working dragDrop function today, but ran into a bit of a
problem, this is what I have so far, my problem is highlighted in the
comments
private function dragToOrders(event:DragEvent):void
{
try
{
var draggedItems:Object = new Object();
draggedItems =
[EMAIL PROTECTED] wrote:
I thought you were dragging Products
From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of bredwards358
Sent: Monday, June 02, 2008 7:18 AM
To: flexcoders@yahoogroups.com
Subject: [flexcoders] Re: Questions
Okay, I kind of get what you're saying, it makes sense however I have
some questions to clear things up further, nothing big, just simple
things. Check below for the blue text, in the meantime I'll experiment,
Thanks a bunch I appreciate it.
Brian Ross Edwards,
Tech-Connect LLC.
--- In
From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of bredwards358
Sent: Monday, June 02, 2008 7:18 AM
To: flexcoders@yahoogroups.com
Subject: [flexcoders] Re: Questions regarding updating dataProviders
after a drag drop
Looking through the posts regarding my search criteria of drap and drop
and Array collection, I couldn't find a post which cleared up the task
of updating a data provider, in this case, an array collection, after an
item is dragged to its datagrid from another. Purely using the default
settings(no
In the AIR application I'm developing, I'm using a local SQL Lite
database, it's been working well, however, after a bit of refactoring, I
came across this error:
RangeError: Index '1' specified is out of bounds.
In this case, '1' is the index of the very first item in the datatable,
Okay, I discovered the solution to my problem. All I had to do was just
check the length of the dataProvider before doing an insert, if the
length of the arraycollection was 0(no entries) then it would amend the
insert statement to insert a zero into the primary key column. If the
length was
= Website;
item.name = Expectal.com;
[EMAIL PROTECTED], bredwards358 bredwards358@
wrote: item.url = http://www.expectal.com;;
item.desc = Your Professional Flash Photo Gallery with Slideshow and
Background Music;
item.tags = Flash, Gallery, Slideshow, Music;
dpRows.addItem(item);
However
After doing some research which consisted mainly of searching through
this forum, I noticed a mantra along the lines of manipulate the
dataProvider, not the controls it populates. It makes sense,
especially since without directly manipulating the primary key of the
very first entry in a database ,
Okay, I'm working on a filter function to sort through information in an
ArrayCollection which is filled by the results of a select statement to
a database. The actual functionaility is modified ever so slightly from
the source I found here:
Forgive the lateness of my response, but thanks all, I solved my
problem, I didn't need to do item editing inside the datagrid at all,
I simply needed to just be able to edit an item. I simply made a state
of the window which contains a form populated with the necessary
information. But what I
Now, I've been coding in flex for about six or seven weeks now and
things seem to be going swimmingly so far, until I now have to climb
the brick wall that is trying use more of the functions of the data
Grid or actually the advanced data Grid than I was ever used to. Given
the sheer number of
Sorry, small bit I forgot, I also have columns which are invisible by
default and need to make them visible during runtime, seems like
there's no way to directly access the properties of individual columns
though I think I'm probably wrong since I'm thinking there's got to be
a way to access the
--- In flexcoders@yahoogroups.com, Marcus Engene [EMAIL PROTECTED] wrote:
And then google for sql injection.
Already taken care of beforehand, I find to be a bit of an annoyance
when the solution to so many problems turn out to be incredibly
simple, apparently too simply for me to readily find.
While working on the login functionality of the application I'm
developing, I noticed that SQL seems to be interpereted differently
than what I'm used to. Here's my current select statement that I'm
using for validation:
sqlText = SELECT * FROM Up18Technicians WHERE TechName = + userName
+ AND
The AIR application that I'm currently developing, gets its data from
a SQL Lite database and does it through whatever select statement it
needs which then puts the results into an array collection variable
which is then passed into the dataProvider for the control. So far,
its just been data
Never mind, I did a bit of messing around and found the solution to be
that I simply had to set the labelField property to whatever column
header I was binding the box to.
Never mind, I found the problem , turns out I wasn't referencing the
database file when I was opening the connection.
I've started implementing the bulk of the database logic in our
current software project, and while trying to get the select statement
to work in populating the datagrid in one window upon creation, I keep
running into this error every time the SQL statement tries to execute.
It keeps saying that
That's fine, I again figured something out a short while ago while
experimenting with importing the text documents. Turns out you can't
have the special characters such as the - or / in the column
header, the actual data in the rows beneath them can have those
characters. So instead of doing a
--- In flexcoders@yahoogroups.com, valdhor [EMAIL PROTECTED] wrote:
Nope - nothing to do with the XML.
You have a comma missing between :Sheet_Depth and :Unique_Product_Code
in your sqlText variable in your insertData function.
Cool, thanks for pointing that out as well. I've figured a few
So, I finish a simple application to turn an XML Document into a SQL
Lite table, however, every time I try to run it, I simply get an error
message in the error log I set up: [b]Error ID:3115 DetailsError #3115:
SQL Error.[/b] As you can see, it's simply not descriptive enough.
Going over my
Here's the Insert statement snippet since it got cut off due to length:
private function insertData(node:XMLNode):void
{//Quite possibly the biggest SQL statement I've ever done
thus far
var sqlText:String = INSERT INTO Avery(Original,
Product_Code, Cross_Reference,
--- In flexcoders@yahoogroups.com, valdhor [EMAIL PROTECTED] wrote:
I don't know whether this is your problem but your Orientation field
has no type in your create table function.
--- In flexcoders@yahoogroups.com, bredwards358 bredwards358@
wrote:
Snip
Sadly, no, but thanks anyway
unorthodox, perhaps you could post the core aspects of the
VB
code and some of us can tell you if it's even feasible and if so, than
how
to move forward.
!k
_
From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED]
On
Behalf Of bredwards358
Sent: Wednesday, April 23, 2008 6:21
As per a suggestion from another member of the forum, I have decided
to repost my question with a more descriptive title. Right now I am
currently in the midst of designing an Adobe AIR application which is
basically a new and improved version of legacy software coded in VB6
(I'm using Flex 3). At
Hi, I'm new to this group so I would like to get my introductions out
of the way before I ask my question. I've recently begun a project at
work which involves an Adobe AIR application coded in Flex 3. It is
essentially a totally new version of legacy software which was coded
in VB 6. I am quickly
app? What
happens on the server (not Flex), what on the client(Flex) and how the
communication between client ans server is handled?
Tracy
From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of bredwards358
Sent: Monday, April
66 matches
Mail list logo