ExecuteSQL problem with Vista

[Bob Simmons]

I've been using environment.ExecuteSQL fine under XP and Leopard with column and row separators set like this:

fmx::ushort colSep = 0xE700;
fmx::ushort rowSep = 0xE701;

(thanks for the suggestion Jake)

But under Vista and FileMaker 10, this isn't working. The data returned appears to be separated by values of 1 for both separators.

Can anyone help?

Thanks

Simon

[Jake Traynham]

Hi Bob,

   I haven't heard from any of our customers about any problems with
this, but that's not necessarily conclusive.  Unfortunately, I don't
have a vista machine to test with, but you could see if the MMQuery demo
works on your machine.  If you call the MMQuery_FindRecords function and
it returns data with fields separated by commas (internally it uses the
0xE700 characters, then replaces them with commas), then it's working
with MMQuery.  If MMQuery isn't working correctly, then we can look into
what the problem may be.

Thanks,
Jake

Bob Simmons wrote:

>
>
>
> I've been using environment.ExecuteSQL fine under XP and Leopard with column
> and row separators set like this:
>
> fmx::ushort colSep = 0xE700;
> fmx::ushort rowSep = 0xE701;
>
> (thanks for the suggestion Jake)
>
> But under Vista and FileMaker 10, this isn't working. The data returned
> appears to be separated by values of 1 for both separators.
>
> Can anyone help?
>
> Thanks
>
> Simon
> --
> View this message in context:
> http://www.nabble.com/ExecuteSQL-problem-with-Vista-tp22906387p22906387.html 
> <http://www.nabble.com/ExecuteSQL-problem-with-Vista-tp22906387p22906387.html>
> Sent from the Filemaker plug-in - Dev mailing list archive at Nabble.com.
>
>

--
Jake Traynham
Owner, CNS Plug-ins
http://www.cnsplug-ins.com/

[Bob Simmons]

Hi Jake

Thanks for the quick response.

MMQuery and my plugin both work fine on my Vista system (running under Parallels on my mac). It now appears that this is a problem only with one specific computer.  I won't get a chance to check MMQuery on the one with the problem until later tonight but I believe it will manifest the same problem.

Do you know if there are settings in FileMaker to do with unicode that might affect this?

Thanks

Jake Traynham wrote:

Hi Bob,

   I haven't heard from any of our customers about any problems with
this, but that's not necessarily conclusive.  Unfortunately, I don't
have a vista machine to test with, but you could see if the MMQuery demo
works on your machine.  If you call the MMQuery_FindRecords function and
it returns data with fields separated by commas (internally it uses the
0xE700 characters, then replaces them with commas), then it's working
with MMQuery.  If MMQuery isn't working correctly, then we can look into
what the problem may be.

Thanks,
Jake

Bob Simmons wrote:
>
>
>
> I've been using environment.ExecuteSQL fine under XP and Leopard with column
> and row separators set like this:
>
> fmx::ushort colSep = 0xE700;
> fmx::ushort rowSep = 0xE701;
>
> (thanks for the suggestion Jake)
>
> But under Vista and FileMaker 10, this isn't working. The data returned
> appears to be separated by values of 1 for both separators.
>
> Can anyone help?
>
> Thanks
>
> Simon
> --
> View this message in context:
> http://www.nabble.com/ExecuteSQL-problem-with-Vista-tp22906387p22906387.html 
> <http://www.nabble.com/ExecuteSQL-problem-with-Vista-tp22906387p22906387.html>
> Sent from the Filemaker plug-in - Dev mailing list archive at Nabble.com.
>
>

--
Jake Traynham
Owner, CNS Plug-ins
http://www.cnsplug-ins.com/

[Bob Simmons]

Hi Jake

I have managed to test another computer that is supposedly identical to the one with the problem and it works fine so I now suspect either a bad installation or a corrupt file.

Thanks for your help.

Bob Simmons wrote:

Hi Jake

Thanks for the quick response.

MMQuery and my plugin both work fine on my Vista system (running under Parallels on my mac). It now appears that this is a problem only with one specific computer.  I won't get a chance to check MMQuery on the one with the problem until later tonight but I believe it will manifest the same problem.

Do you know if there are settings in FileMaker to do with unicode that might affect this?

Thanks

Jake Traynham wrote:

Hi Bob,

   I haven't heard from any of our customers about any problems with
this, but that's not necessarily conclusive.  Unfortunately, I don't
have a vista machine to test with, but you could see if the MMQuery demo
works on your machine.  If you call the MMQuery_FindRecords function and
it returns data with fields separated by commas (internally it uses the
0xE700 characters, then replaces them with commas), then it's working
with MMQuery.  If MMQuery isn't working correctly, then we can look into
what the problem may be.

Thanks,
Jake

Bob Simmons wrote:
>
>
>
> I've been using environment.ExecuteSQL fine under XP and Leopard with column
> and row separators set like this:
>
> fmx::ushort colSep = 0xE700;
> fmx::ushort rowSep = 0xE701;
>
> (thanks for the suggestion Jake)
>
> But under Vista and FileMaker 10, this isn't working. The data returned
> appears to be separated by values of 1 for both separators.
>
> Can anyone help?
>
> Thanks
>
> Simon
> --
> View this message in context:
> http://www.nabble.com/ExecuteSQL-problem-with-Vista-tp22906387p22906387.html 
> <http://www.nabble.com/ExecuteSQL-problem-with-Vista-tp22906387p22906387.html>
> Sent from the Filemaker plug-in - Dev mailing list archive at Nabble.com.
>
>

--
Jake Traynham
Owner, CNS Plug-ins
http://www.cnsplug-ins.com/