Stonefield Query
 
Stonefield Site Map
Stonefield Support

  Overview
  Submit Support Ticket
  Forums
  Online Help Files
  Services
  Pre-Sales Support
Online Webinars
Video Demonstrations
Feature Requests
  Software Maintenance
  Support Testimonials
  FAQ's
Quick Links
Buy Now!
Download Free Trial
Watch a Video
Contact Us

 
 You are here: Support * Support Forums   Search

 Stonefield Query Support Forum

Welcome to the Stonefield Query Support Forum. Please note that in order to participate in the support forums, registration at our site is required. If you are already a member of our site, please sign-in.

 

Subject: Issue with QW custom fields

Topic is locked   

Author Messages
denisv
Posts:56

05/16/2007 3:35 PM Alert 
I have a report with Qw that is referring to CustomText10 in doc items. It
is returning '???' only and when I check it as part of a formula it looks
like it is taking the DocHeader CustomText10 instead.

I tried to use an alias in the advanced select query:
DOCUMENTITEMS.CUSTOMTEXT10 as PurchType_DV

but this returns a blank field that appears to be in date format.

Can you assist.
tmansuy
Posts:161

05/16/2007 4:28 PM Alert 

Hi Denis,

It appears that some of the fields in the Quotewerks database are actually memo fields (such as the DOCUMENTITEMS.CUSTOMTEXT10), while Stonefield Query is trying to refer to them as fixed length character fields.

I have sent you an email with a file attached that should solve the problem for that particular field temporarily, along with instructions on modifying the file I sent to handle other fields.

This issue will be resolved in our next product release. Meanwhile, if anyone else runs in to this problem, feel free to send an email to support@stonefieldquery.com, requesting the 'fix' file.

Trevor

Topic is locked



ActiveForums 3.6

 
 
   Privacy Statement  |  Terms Of Use
© 1996-2008 Stonefield Software Inc. All rights reserved.